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:57 AM

xps35 replied to a thread Print Report from Multiple Forms in Reports

I don't think this is a good solution. If only one form is opened it won't work. That might be your problem. If both forms are opened you might end...

4 replies | 54 view(s)

Today, 03:56 AM

isladogs replied to a thread Record selection with the vertical scrollbar on a continuous subform in Code Repository

Hi The scrollbar always scrolls until the last record is visible - in your case Ken Zuter - but cannot be scrolled further for obvious reasons. ...

5 replies | 4604 view(s)

Today, 03:43 AM

richiewillmott replied to a thread Running two filters at the same time?? in Programming

Everything is working fine but now my report is placed in a "navigation form" it keeps popping up with "Runtime error 5" on Me.FilterOn=True even...

4 replies | 28 view(s)

Today, 03:35 AM

Welshgasman replied to a thread insert records from excel file in Programming

Link to it. Then use a query.

1 replies | 7 view(s)

Today, 03:30 AM

Lesg replied to a thread Print Report from Multiple Forms in Reports

Can you expand on this suggestion please, i.e.is this via the query editor or in VBA code?

4 replies | 54 view(s)

Today, 03:29 AM

uoghk started a thread insert records from excel file in Programming

how to ask a Excel file (which is a list of ClientNo,ClientName,PhoneNo) then insert all records into Access database?

1 replies | 7 view(s)

Today, 03:04 AM

Remster replied to a thread Record selection with the vertical scrollbar on a continuous subform in Code Repository

Thanks for that. It would be interesting to know what happens for you on the "final 'screen' of records", because it works fine for me. I wonder if...

5 replies | 4604 view(s)

Today, 02:52 AM

CJ_London replied to a thread Running two filters at the same time?? in Programming

I would just point out that your filters are not correct for general use Filter1 = " LIKE '" & Me.List306 & "'" You use LIKE in conjuction with...

4 replies | 28 view(s)

Today, 02:22 AM

richiewillmott replied to a thread Running two filters at the same time?? in Programming

Yes! That works, thanks very much :D

4 replies | 28 view(s)

Today, 02:18 AM

xps35 replied to a thread Running two filters at the same time?? in Programming

Try Me.Filter = Filter1 & " And " & Filter2/CODE]

4 replies | 28 view(s)

Today, 02:06 AM

richiewillmott started a thread Running two filters at the same time?? in Programming

Hi, I am trying to run two filters at the same time in my Access Database. Both filters work individually but I can't get them to work at the same...

4 replies | 28 view(s)

Today, 12:24 AM

ArviLaanemets replied to a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

Had a look at your database, and it is non-formalized in worst possible way ever! All those tables in your database can be condensed to single table....

5 replies | 41 view(s)

Today, 12:05 AM

sheckay replied to a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

The form that is attached to the big query is named MinutesofProdReportFrm The query that is based on smaller queries is called testQuery

5 replies | 41 view(s)

Yesterday, 11:16 PM

ArviLaanemets replied to a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

Looks like you need a left join query on 3 tables (tables for users, stations, and station notes). Something like SELECT u.LastName, u.ForeName,...

5 replies | 41 view(s)

Yesterday, 11:06 PM

June7 replied to a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

Post sample tables and attempted query. If you want to provide db for analysis, follow instructions at bottom of my post. This is usually the...

5 replies | 41 view(s)

Yesterday, 10:53 PM

sheckay replied to a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

I just tried creating a query for each table, and then a query based on those queries. Same result. Probably not news to all of you experienced...

5 replies | 41 view(s)

Yesterday, 09:50 PM

sheckay started a thread Blank Query due to criteria not being met in some fields, not all of them in Queries

Hello. I have a query that is based on many tables. It searches all of the tables for records that have the current date (in the date field) and also...

5 replies | 41 view(s)

Yesterday, 08:58 PM

twgonder replied to a thread Several The types of currency in Access

Thanks Alan, but someone else, new to the Forum like me, might stumble upon this thread.

6 replies | 724 view(s)

Yesterday, 08:37 PM

twgonder replied to a thread Get rid of the dang "$" in currency already! in Access

Okay, let's wrap up the number and currency formatting issues. I modified the original db to have a lot more functionality and you can test entering...

17 replies | 266 view(s)

Yesterday, 07:15 PM

GraeagleBill replied to a thread

Len(Dir.............. not finding file in Programming

"GCC-Data.mdb" is the name of the backend. I think there's an internal table issue that I missed during the advance of the app's version.

3 replies | 43 view(s)

Yesterday, 06:33 PM

pbaldy replied to a thread

Len(Dir.............. not finding file in Programming

Bill, you want my eye doctor's name? He's right down the street from you on Lakeside. ;)

3 replies | 43 view(s)

Yesterday, 06:19 PM

orange replied to a thread

Len(Dir.............. not finding file in Programming

????Your file name includes Database in the function, but Data in the directory list.

3 replies | 43 view(s)

Yesterday, 05:57 PM

GraeagleBill started a thread

Len(Dir.............. not finding file in Programming

Pretty simple stuff. What am I missing? With my fuzzy brain at the end of the day, nothing will surprise me!

3 replies | 43 view(s)

Yesterday, 05:09 PM

isladogs replied to a thread Record selection with the vertical scrollbar on a continuous subform in Code Repository

Just discovered this over a year late! I was interested in the idea but soon realised that it had some flaws - most notably it is impossible to...

5 replies | 4604 view(s)

Yesterday, 03:24 PM

orange replied to a thread Search Function on form doesn't return any data from table even thought the info in on the table in Forms

drunyan0824, Yes a new thread simply because of size. Also recommend cascading combo where select from Category, then pick the wire within the...

51 replies | 955 view(s)

Yesterday, 03:22 PM

twgonder replied to a thread How to stop entry of decimal in table Datasheet view in Access

In the validation for the field I put this, and it worked: >-999 And <9999 And Int()= I had no luck using Between, it doesn't seem to like an "and"...

8 replies | 125 view(s)

Yesterday, 03:03 PM

orange replied to a thread Lookup table in Access

Via Google: Withdrawal time, as relating to veterinary medicine, is defined as the time required after administration of a drug to a dairy cow ...

9 replies | 370 view(s)

Yesterday, 02:11 PM

moke123 replied to a thread Lookup table in Access

You might be. I don't think anyone of us is sure of the question. Welcome back, BTW. Hope you had a nice trip.

9 replies | 370 view(s)

Yesterday, 01:21 PM

xps35 replied to a thread Data Type? in Access

If the maximum length is 2, you could try: SELECT tPGM FROM T1 ORDER BY IIf(Len()=1 And IsNumeric(),"0" & ,IIf(Len()=2 And Not...

9 replies | 152 view(s)

Yesterday, 01:03 PM

NoellaG replied to a thread How to stop entry of decimal in table Datasheet view in Access

Can't you put a trigger/data macro on the table to do the job?

8 replies | 125 view(s)