Search results

oops no. Have already moved to Access Thanks

Am wondering if anyone knows of a way to create an ad hoc data query from a form, which also shows check boxes for all fields. Basically, I would like to have the user be able to check the data box for the fields they want to see, then run the query. The query would only display those fields...

Am wondering if anyone knows of a way to create an ad hoc data query from a form, which also shows check boxes for all fields. Basically, I would like to have the user be able to check the data box for the fields they want to see, then run the query. The query would only display those fields...

Ever have a "duh" moment. I just rebuilt the query and it works fine.:)

Deleting records from a query is not a problem. I define databases for users to do that all the time. You certainly don't want users deleting directly from the tables. Access uses queries to update tables all the time - hense append queries, update queries, etc. This is an especially easy...

I have a query which runs off one table. No calculations, no code, etc. just pulling fields down from the table. End user entered a duplicate record and is unable to delete. Have verified all delete functions are greyed out, and unable to delete record. I would think a simple on/off switch...

I have a spreadsheet with thousands of lines of data. Each of the first 5 columns have selections, the combination of which ultimately drive the display of column 6. Using filters on each column I can narrow the selections that display in column 6. What I need to do is devise a dummy proof...

Wouldn't you know that as soon as I'd post a request I'd figure it out. I used a DateDiff funtion within the initial Calculation before trying to run the average. So I used... TimeDiff: IIf([Time2]-[Time1]<0, (DateDiff("n",[Time1], [Time2],)+1440), DateDiff("n", [Time1],[Time2])) Then...

I am having trouble calculating an average, both in reports and in a query, for a series of calculated time differences. Basically this calculation takes into account times spread across midnight in a 24 hour clock. Therefore if Time 1 was at 23:50 and Time 2 was at 00:30, I'd get 40 minutes...

When building the custom user interface ribbon, I used groups just as much as possible. However, on a few groups, I had to build the pieces I wanted. They work great, but they basically are turned on all the time. If you click on one when not appropriate, you get a macro error and the...

I have a calculation that subtracts two time values to come up with a difference in minutes. I want to take these minutes and generate an average difference in the reports. However I get an error indicating the calculation is to complexed. I thought perhaps to create a new field in the...

can't get to the site you indicated. Can you copy and paste some information instead?

I need some recommendations on the best way to write an error scipt in the code. Basically, I want to prevent the "canned" MS error message that includes the debugging, etc. For example, if someone starts to run a report by date range and then cancels before all the parameters are met -...

Thanks for the reply. Actually, I needed the quotes exactly where they were. My issue turned out to be not including the And within the second set of quotes. Thanks

Below is the entire statement: DoCmd.OpenReport stDocName, [acViewReport], , "[Audit Month] ='" & stDocNameMonth & "'" And "[Audit Year] ='" & stDocNameYear & "'" The last section starting with Audit Month is the where statement. Basically I want to insert a month and year filter based on...

I have a form which have address fields that I need to link into the header of reports. The form is a popup that allows for facility address information. This is a one-time entry and is linked back to tbl_default_location. I then entered a series of unbound text fields that I linked back to...

I need to be able to have two field filters defined in the where condition of a DoCmd.OpenReport command. Both of the filters work fine individually, but when I try to put them together I am constantly getting errors. I have not found any references that indicate how to include more than one...

Yes, I figured that!!! Nothing like doubling the work when you need to make a change.....uuuugh

I have a table that I have set up a validation rule that prevents staff from entering data more than 45 days old... My problem is that Team Leaders want a work around so they can still enter the data if necessary. I know that work arounds are not allowed with validation rules, so I was...

PBaldy - That's just what I needed... Thanks.