Activity Stream - Microsoft Access Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

Today, 12:50 AM

DMT Dave started a thread Adding Excel Range To Email Body in Access

Hi Guys, I have found 2 functions to try and output a specific Excel Sheet to Email Body, watched the video of it and followed apart from renaming my...

0 replies | 0 view(s)

Today, 12:47 AM

Raveen1609 replied to a thread Counter Number and Tab index for form footer in Access

Regarding the setfocus, on the cmdprint command, the default property is set to yes. After entering the datas in the subform, how do I set tab...

6 replies | 31 view(s)

Today, 12:43 AM

Raveen1609 replied to a thread Counter Number and Tab index for form footer in Access

Thanks for your reply. I have attached the sample db. Yes after setting Now() as default value is working ok. But I need another field to setfocus...

6 replies | 31 view(s)

Today, 12:34 AM

Gicu replied to a thread Counter Number and Tab index for form footer in Access

I think that is happening because you are dirtying the form by assigning Now() to a control programmatically. Again, hard to say without seeing your...

6 replies | 31 view(s)

Today, 12:21 AM

ArviLaanemets replied to a thread How to sum a textbox based on two other values in Access

Let's try to analyze your formula. =IIF(Condition, ExpressionWhenTrue, ExpressionWhenFalse) 1. Obviously, you missed a delimiter before SUM(),...

6 replies | 57 view(s)

Yesterday, 10:27 PM

ssanfu replied to a thread How to sum a textbox based on two other values in Access

Do yourself a favor and DO NOT use spaces in object names. Object names include Field names, Table names, Query names, Form names and Report names....

6 replies | 57 view(s)

Yesterday, 10:09 PM

Raveen1609 replied to a thread Counter Number and Tab index for form footer in Access

The autonumber field is jumping numbers, so not consistent. So I created another field and use dmax function. I have used this function in the...

6 replies | 31 view(s)

Yesterday, 09:55 PM

ssanfu replied to a thread Counter Number and Tab index for form footer in Access

Not sure what this means. The autonumber field is not providing a unique number for each record? Please explain.....

6 replies | 31 view(s)

Yesterday, 09:44 PM

ssanfu replied to a thread Using between dates criteria from form to query? in Queries

Yes, Paul's solution is better. I tend to use "brute force" and use VBA to get things done. Glad you got it working.

10 replies | 54 view(s)

Yesterday, 09:29 PM

Gicu replied to a thread Counter Number and Tab index for form footer in Access

Without seeing you db it is almost impossible to give you an answer for the question number 1. As for the second one just set the Default property of...

6 replies | 31 view(s)

Yesterday, 09:07 PM

Raveen1609 started a thread Counter Number and Tab index for form footer in Access

I am developing a billing application for my small business. I have following couple of issues in Access 2016. 1. AutoNumber for Invoice ID is not...

6 replies | 31 view(s)

Yesterday, 07:46 PM

Joseppy replied to a thread Upgrading from 2007 to 365. Need some guidance in Access

I looked at the link you suggested and most of my system is now working. Have a few other issues to address yet. Thanks for your help.

5 replies | 110 view(s)

Yesterday, 07:40 PM

GraeagleBill started a thread Error 53 and 76 trying to copy file to Sharepoint in Programming

Can't find any forum threads that might have answer(s) to the difficulty I'm having trying to copy a file to a Sharepoint. In the app's settings we...

0 replies | 25 view(s)

Yesterday, 07:11 PM

tracetrimble replied to a thread Inspection Scheduler in Access

Thanks. I think you are picking up what I'm laying down here. I'm absorbing your advice, but just a quick response to one point: we don't do...

2 replies | 42 view(s)

Yesterday, 06:41 PM

Micron replied to a thread Inspection Scheduler in Access

I've dabbled in a lot of PM and corrective data, both with fixed and variable frequency requirements and will say that for this, 11 date fields in a...

2 replies | 42 view(s)

Yesterday, 06:19 PM

Pam@NZ replied to a thread Using between dates criteria from form to query? in Queries

Thanks - but no, returning call error - I imagine the database owner is not allowing that. (caveat that's the first time I've created and run a...

10 replies | 54 view(s)

Yesterday, 06:05 PM

Pam@NZ replied to a thread Using between dates criteria from form to query? in Queries

Thanks for the suggestion and offer of providing code... but the form is unbound - only for entering criteria for the query. I am not displaying...

10 replies | 54 view(s)

Yesterday, 06:03 PM

pbaldy replied to a thread Using between dates criteria from form to query? in Queries

By the way, if it's slow you might consider a pass through query to the back end if that's an option.

10 replies | 54 view(s)

Yesterday, 06:02 PM

pbaldy replied to a thread Using between dates criteria from form to query? in Queries

Happy to help!

10 replies | 54 view(s)

Yesterday, 05:58 PM

Pam@NZ replied to a thread Using between dates criteria from form to query? in Queries

Thanks for the suggestion and offer of providing code... but the form is unbound - only for entering criteria for the query. I am not displaying...

10 replies | 54 view(s)

Yesterday, 05:56 PM

Pam@NZ replied to a thread Using between dates criteria from form to query? in Queries

Brilliant! - that worked I was calling via ODBC which made it very slow so needed to create a tmp table with all recs first and then extract from...

10 replies | 54 view(s)

Yesterday, 05:55 PM

Pam@NZ replied to a thread Using between dates criteria from form to query? in Queries

Brilliant! - that worked I was calling via ODBC which made it very slow so needed to create a tmp table with all recs first and then extract from...

10 replies | 54 view(s)

Yesterday, 05:46 PM

tracetrimble started a thread Inspection Scheduler in Access

I wrote a db to manage projects (wastewater treatment industry) for my company, and I need to add the ability to schedule and report upcoming...

2 replies | 42 view(s)

Yesterday, 05:36 PM

ssanfu replied to a thread Using between dates criteria from form to query? in Queries

Welcome to the forum. I would use the Me.Filter and Me.FilterOn properties to filter the form. Another method is to use VBA to create the WHERE...

10 replies | 54 view(s)

Yesterday, 05:30 PM

pbaldy replied to a thread Using between dates criteria from form to query? in Queries

Try something like: >=Nz(!!, #1/1/2000#) And <=Nz(!!, #12/31/2039#) Basically using dates that are before/after anything in your data.

10 replies | 54 view(s)

Yesterday, 05:22 PM

Joseppy replied to a thread Upgrading from 2007 to 365. Need some guidance in Access

I didn't think the code buiulder was causing the problem. Just the fact that I had quite a bit of code that I added. I am getting errors about 32...

5 replies | 110 view(s)

Yesterday, 05:18 PM

Joseppy replied to a thread Upgrading from 2007 to 365. Need some guidance in Access

I think you hit the nail on the head. The errors were showing 32 to 64 bit. I will check out the link and see if I have any more issues. Thanks...

5 replies | 110 view(s)

Yesterday, 05:10 PM

ssanfu replied to a thread Upgrading from 2007 to 365. Need some guidance in Access

@Joseppy, Welcome to the forum. I have to say I am confused as to why you think the Code Builder (aka Expression Builder) has anything to do with...

5 replies | 110 view(s)

Yesterday, 04:16 PM

orange replied to a thread How to Close Database if Inactive in Programming

See this link by Jeff Conrad Kick Users Off -Detect Idle Time for ideas and/or This one from Microsoft

2 replies | 40 view(s)

Yesterday, 04:06 PM

Pam@NZ started a thread Using between dates criteria from form to query? in Queries

Hi there and thanks in advance for any help, I have a simple unbound form with two text fields in which two dates are entered: Date From and Date...

10 replies | 54 view(s)