Search results

Hi I have a query which pulls vehicle inspection data, and invoice data resulting from any faults found. I have several query fields which should display a value which, at point of data entry, was selected from a combo box pointing at a table. On the input form in the combo box the text field...

Thanks VBAInet, Your code works perfectly. And also thanks for the explanation as to why Access was converting a 1 to December. I had no idea about this, but its handy to know. I have checked the field by the way, and it is a date field, and not a text field.

Hi I have a report which displays the 2 query parameters used to generate it. The user enters a month number and year number. I have used the following statement: Format([Reports]![MyReport]![Month Number], "mmmm")) When i pull off a report for January 2010 I get the results i expect...

I only make changes to my front end. Every one here has their own local front end on their machine, and the data tables sit on the server. If i'm making tables changes then obviously i make sure people have got out of the DB. But I never do when changing the front end because its local. I...

having done a bit more digging i only get the problem when i try to run/edit 1 report. every thing else works fine

nope. I checked that one as well. :(

Hi I have a database which has a front end on 6 local machines, and the data tables sat on the server. I have just started getting the error message "database has been placed in a state of admin by...." as i am editing some reports which need to be updated, which live in the local front end on...

I now know exactly what is causing the problem. When ever we get a breakdown, we create a jobsheet which is later turned into an invoice. All jobsheets and invoices have a matching unique ID, known as an FI Number. When the query runs, it looks at the FI number which joins the invoice & job...

Hi I have a query which should total all fuel expenses, by month for the last 12 months. however, when i run the query, it only displays the first cost incurred by a vehicle in each month column, and not a total of all fuel costs. here is the SQL: TRANSFORM...

i'll give it a whirl and see what comes back thanks for the help!

I have finally had a chance to look at this as our records have been updated (it used to be daily but we are having a new system put in place which has affected things) The query still returns the type mismatch in expression error :mad: I have limited the date parameter on the query so that it...

Great! Thanks very much..! :)

I'm not actually doing this right now, but i have been wondering if it is possible for future use Can you, through form controls allow users to select AND/OR and other SQL statements to create a dynamic query? For example: A list box allows a user to select AND/OR so the query could find...

Thanks again for your reply. After thinking about it, it could also cause problems with the relationships which are used to pull in other details I am still waiting for the files to be updated (we've got a lot going on with a new sql system so its low priority...) i will let you know what happens

the latest few transactions are credits back to customers, rather than standard transactions maybe this is why its throwing back an error? i'll have to check again next week after we've run an end of day on our current system we are also migranting to an sql database but our 3rd party...

The dbf files are all linked tables. All the query does is append the necessary fields out of these unmodifiable dbf files..... and then add in some other data based upon the appended fields values.... into an Access 2007 table Probably a daft question, but how do you import to a temp...?

Thanks for your replies A) I am only importing 1 numeric field, and this would never be blank because it is from a static table with contact details in it. B) I am not using any routine or code to automate the process. The user clicks an import button, and it runs a series of appends and...

Hi I have a database which relies on importing data from .dbf files generated from a DOS system The import has worked fine until today and I am now recieving a type mismatch in expression error. I have not made any changes to the database, and it was working the last time data was imported I...

The count functions etc are built into the report footers rather than done in the query

Hi I have a database which relies on importing data from .dbf files generated from a DOS system The import has worked fine until today and I am now recieving a type mismatch in expression error. I have not made any changes to the database, and it was working the last time data was imported I...