Search results

Hey Gang, No one in my office can help me. I'm working to connect to tables in an IBM AS/400 environment. Every time I go to link to a table, it does not show all the table in the AS/400. I know they exist and I can access them in AS/400 interface, but not through MS Access. Anyone know...

Hey Gang, No one in my office can help me. I'm working to connect to tables in an IBM AS/400 environment. Every time I go to link to a table, it does not show all the table in the AS/400. I know they exist and I can access them in AS/400 interface, but not through MS Access. Anyone know...

THANKS...JC10001...I feel like an idiot..."End IF" so simple! As for your idea of the option buttons, how wohe group of would I set the group of button to be only one or the other?

Please help, I'm a newbie...I don't know VBA all that well (I know those newbie can be a pain...) I'm trying run a code that require one of two check box fields to be checked. If both are checked or if neither are checked, a msgbox appears and the user cannot save the record until only one is...

FoFa and Ancient one thanks for replying to my post... Basically, I have three countries with linked data tables...all tables have the same structure and data fields. I have three queries that are the same but each use a different linked country tables. I'm trying to gather information by...

Please help, I'm new to VBA and I can't seem to figure this out... I'm trying to run a looper to speed up my query...basically...I have a form that is connected to a table with a one field called "week." So far it runs fine unitl I get to the end of the table and I get an error msg stating...

I'm new to VBA...here's what I'm trying to do. I have a main form which is the user interface and would like to create a button that will open a table and apply a filter to that table. Here's what I got... Private Sub OpenPFTable_Click() On Error GoTo Err_OpenPFTable_Click Dim stDocName...

In writing a formula in my query...and I keep getting an error... Projected: IIf(Weekday(Now())-1=0,0,[SALES_PIECES_WTD]/DLookUp("[day_cum_perc]","tbl Day Percent","[Week]=[Week_Number] and Weekday(Now())-1")) The error I keep getting is with the DLookUp part. I have the Week_Number declared...

Hey Gang, Is there a way to clock how long a query runs? I have to decide which of the two queries I have built would run faster. And I think by seeing how fast a it takes can help decide which would be the most effecient. Thanks, Jan