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, 03:00 AM

DMT Dave replied to a thread

Renaming Different Files In Same Folder in Access

Hi Guy's thank you for responding, Can I apologize, i have slightly changed the goal post here, what I thought of afterwards is changing MkDir...

4 replies | 95 view(s)

Today, 02:25 AM

Welshgasman replied to a thread Selecting Records by VBA in a continuous form in Forms

Whilst it would be by CF, I believe you would need to invoke the CF by VBA, so Google that as well. ...

2 replies | 33 view(s)

Today, 02:23 AM

Minty replied to a thread How to debug docmd.openquery in Queries

A simple select query won't give you an error with a null value. What will is the use of a function that doesn't accept a null value as a valid...

3 replies | 27 view(s)

Today, 02:14 AM

Welshgasman replied to a thread How to debug docmd.openquery in Queries

A little hard really. :( How big is the query? You could get the sql and then inspect each of the fields in the immediate window perhaps? I'd...

3 replies | 27 view(s)

Today, 12:11 AM

AccessHelp23 replied to a thread How to debug docmd.openquery in Queries

I mean how do I know which table and column are returning the null and causing the runtime error .

3 replies | 27 view(s)

Today, 12:10 AM

AccessHelp23 started a thread How to debug docmd.openquery in Queries

Hello. I have a statement docmd.openquery that displays a Table successfully every time except a few times. I see an error runtime error 94-...

3 replies | 27 view(s)

Yesterday, 09:59 PM

kd2017 replied to a thread Selecting Records by VBA in a continuous form in Forms

It sounds like you want conditional formatting https://www.google.com/search?q=microsoft+access+continuous+form+conditional+formatting

2 replies | 33 view(s)

Yesterday, 09:27 PM

Peter5164 started a thread Selecting Records by VBA in a continuous form in Forms

I have a Continuous Form which displays all the sections of a document. What I want to do is have a function that Cycles through all the records and...

2 replies | 33 view(s)

Yesterday, 06:47 PM

journeyman started a thread Prevent edit to an Outlook mail item field in Modules

I know this question is not strictly an Access issue, however, I am opening an MS Outlook mailitem from Access. It's function is to display only...

0 replies | 35 view(s)

Yesterday, 05:44 PM

Perfac replied to a thread Form displays no controls when source have no records. in Forms

The query is updateable. I am studying Micron's reference, and preparing a sample which I will post. As you know sometimes things just get fixed...

12 replies | 111 view(s)

Yesterday, 05:34 PM

CJ_London replied to a thread Form displays no controls when source have no records. in Forms

with allow additions set to yes, then the 'new entry' should appear for the user to complete. However if your recordsource is not updateable, it...

12 replies | 111 view(s)

Yesterday, 05:19 PM

orange replied to a thread

Renaming Different Files In Same Folder in Access

Dave, Can you show some examples -what you have -what you need - and the issue of multiple depots?

4 replies | 95 view(s)

Yesterday, 05:14 PM

moke123 replied to a thread

Renaming Different Files In Same Folder in Access

Personally I like using fso when dealing with files and folders. Much easier to work with the methods like FileExists, getBaseName, BuildPath,...

4 replies | 95 view(s)

Yesterday, 05:14 PM

Perfac replied to a thread Form displays no controls when source have no records. in Forms

"q06PrgmmngSbjcts" is the name I gave to the applicable query, the source for the form applicable here. I just opened a new DB in Access, created...

12 replies | 111 view(s)

Yesterday, 05:12 PM

orange replied to a thread Query to return only the Key values where joined values match multiple values in a another table. in Queries

I tend to agree with June --a table for each project is rarely a good design. I recommend you review "stump the model". A bit of testing of...

2 replies | 42 view(s)

Yesterday, 05:04 PM

orange replied to a thread Form displays no controls when source have no records. in Forms

What is q06PrgmmngSbjcts? I agree with Micron's advice.

12 replies | 111 view(s)

Yesterday, 05:01 PM

Micron replied to a thread Form displays no controls when source have no records. in Forms

Perhaps review this to see if it will help http://allenbrowne.com/casu-20.html

12 replies | 111 view(s)

Yesterday, 04:46 PM

Perfac replied to a thread Form displays no controls when source have no records. in Forms

I will, it may take a while.

12 replies | 111 view(s)

Yesterday, 04:42 PM

pbaldy replied to a thread Form displays no controls when source have no records. in Forms

Can you attach the db here, or a representative sample?

12 replies | 111 view(s)

Yesterday, 04:37 PM

Perfac replied to a thread Form displays no controls when source have no records. in Forms

Hi Paul. Some people on forums do believe setting Data Entry to No will make a difference. I do not experience that. Yes, I can add a record in the...

12 replies | 111 view(s)

Yesterday, 04:22 PM

pbaldy replied to a thread Form displays no controls when source have no records. in Forms

I would bet that the source query won't allow additions. It doesn't matter what the form setting is if that's the case. Edit: open the source...

12 replies | 111 view(s)

Yesterday, 03:51 PM

Perfac replied to a thread Form displays no controls when source have no records. in Forms

Hi CJ. If a new user starts using the app from starters and want to capture the first record, the controls must display to be able to capture the...

12 replies | 111 view(s)

Yesterday, 03:47 PM

June7 replied to a thread Form displays no controls when source have no records. in Forms

Why does this happen? Is AllowAdditions property set to No?

12 replies | 111 view(s)

Yesterday, 03:39 PM

CJ_London replied to a thread Form displays no controls when source have no records. in Forms

So what do you want to do if there are no records?

12 replies | 111 view(s)

Yesterday, 03:31 PM

June7 replied to a thread Query to return only the Key values where joined values match multiple values in a another table. in Queries

I vote against individual table for each project. The queries you describe can be complicated. Suggest you build a db schema and post it here for...

2 replies | 42 view(s)

Yesterday, 03:25 PM

Perfac started a thread Form displays no controls when source have no records. in Forms

If the source table or query have no records, the controls on the form display in design view, but do not display in form view. Somebody probably...

12 replies | 111 view(s)

Yesterday, 02:33 PM

All Thumbs started a thread Query to return only the Key values where joined values match multiple values in a another table. in Queries

Context- I have experience building basic databases to capture, query and report mostly text based data. I have recently started a new role and...

2 replies | 42 view(s)

Yesterday, 01:57 PM

moke123 replied to a thread a control still has focus at the LostFocus event (?) in Programming

Another option is to shift the focus to another control before hiding. I recently noticed, not sure if it existed in earlier versions of access, that...

5 replies | 88 view(s)

Yesterday, 12:53 PM

June7 replied to a thread

Renaming Different Files In Same Folder in Access

You could specify files on/after given date or a filename pattern: filename LIKE "*Capture*" or Instr(filename, "Capture") > 0

4 replies | 95 view(s)

Yesterday, 11:33 AM

isladogs replied to a thread a control still has focus at the LostFocus event (?) in Programming

I don't find it necessary to re-enable the control. Why do you need to do so?

5 replies | 88 view(s)