Search results

I am trying to enter dates in a form that calls a report that invokes a query that uses the dates. It has been a less then satisfying experience. I am getting a Run-Time error 3122. Is it possible and I need to work on syntax or do I need to think of another way? BTW how do I lookup the Run-Time...

Thanks Paul, You gave me just the direction I was looking for. Jim

Some sage advise please... I need to write a report that shows beginning balance current period detail and ending balance. I have as input a transaction table. I know to get the period end and begin dates with a form. I am thinking of creating 3 queries and using dlookup to get the beginning and...

Thank you Thanks for taking the time to help.

Just as in real life, I have a problem with relationships. I am trying to mate a MSSQL table with a Access table. The only commonality seems to be phone number. But of course the Access Table has it defined as ten bytes (area code, exchange, Line number) and the MSSQL table has a field for...

Thank you. That did the trick. Jim

Paul I went to the backend and changed the format to short and that seemed to remove the time. Is their a better way to remove the time? Thanks Jim

I have looked but have been unable to find the answer in past posts and this must be a common problem. I wish to include all records up to and including a date passed in the prompt "Criteria: <=[enter end date]". I changes the date format in the back end to short and I am in the US. However I...

Thanks Pat, What I would like to do is use the same filter for a report. So if the form is filtered to show only blue widgets and the user prints a report it would only show blue widgets. I believe I can pass it with a TempVar like.. SetTempVar FilterString, Me.Filter But how do I retrieve and...

I am modifing the Inventory templete from Microsoft. A form is displayed (inventory transaction list) and you can select a filter for the data. Also on that form you can select a report. I would like to have the report respect the filter. I can see that the filter string is being stashed in a...

I have created an application that is being used via runtime. Everything worked well until I started exporting reports to .rtf files. Now the application chokes when the export is run, everything works swell for me. I believe it is a matter of trust. The user has been getting the trust message...

Great .. Thanks Works perfect

I would like to load the current date into "survey date" if the status indicates the survey has been done and the survey date is empty. As must be obvious I am new to Access. This is the code I put in the change event. Any help will be greatly appreciated. I am using Access 2007 Private Sub...

I have exclusive use of the copy I am trying to delete the objects from.

The objects are not open. One of the objects I am trying to delete is an error table from an import and the other is a report. Thanks Jim

I have created a database with Access 2007 and would like to remove some tables and reports that do not work as I had planned. I have tried to select them from the navigation pane and use the right click menu, however the delete option is grayed out. Thanks Jim