Search results

I am not yet comfortable with date compares. Would someone please tell me how this should be done? I present a form asking for start and end date and want to restrict report data to that date range. Thanks Jim Private Sub Report_Open(Cancel As Integer) Dim dteStart As Date Dim dteEnd...

Would someone please tell me where I have gone astray? = Dsum("[RMA Qty]","Inventory Transactions", "[Inventory Transactions]![created Date]< Cdate([forms]![askdate]![txtStartDate])") Thanks Jim

The code below displays the form and allows me to enter the dates then gives me an runtime 2450 error on the next statement. I would appreciate someone taking a look. Thanks Jim Private Sub Report_Open(Cancel As Integer) Dim StrBegDate As String Dim StrEndDate As String ' Put the form and...

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...

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...

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...

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...

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...

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 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