Recent content by NeilPattison

Thanks for your reply, however I have now sorted this. I thought the issue was more complicated than it actually was. The issue was actually in the source data coming from the excel spreadsheet, so my database was working correctly all the time.

I have a problem with a database I'm maintaining after I have carried out an update query. I have a macro that imports data from an excel spreadsheet onto a temporary table, which then runs the update query to my main table. This all works fine and the data is updated correctly. The problem...

This problem is now resolved

I need to be able to write a formula that will use the vlookup function to check 2 columns and not just one. I have a worksheet that has a table of names with each having there own unique number. On another worksheet information is added and I need to check that the correct unique number is...

I have a database table that is regularly updated from a spreadsheet, using the transferspreadsheet option in a macro and then using an append query. So the spreadsheet is converted into a table called "temp" and then the append query adds it to the original access table. In the tables the...

Thanks forgot about that wizard. Works great

Hi everyone I have two tables that are matched by the primary key of first table (by matched I mean parent/child on a form). I want to be able to write a query that shows the records in the first table (tblDetails) that don't have a match in the second table (tblfigures). I have attached an...

Thanks a lot

Hi everyone, I have a list of grid references in a column in MS Excel in the form of two letters and then 4 numbers (i.e. SE4063). I need to use a formula to select certain bits of this data(the first two letters and the 1st and 3rd numbers) which creates a grid square number (the result in...

Hi all, I have a form that runs from a query which combines data from 2 tables. I am trying to set up a filter on the form using a number of combo boxes and text boxes and a command button to fire it but I keep getting the above error (on the .Filter = strFilter line) and I can't see what the...

ve just figured it out actually. You need to hold down the shift button as the database is opening

thanks for replying harleyquinn the menu bar isn't there to be right clicked. Its the menu bar that I need to be showing once thats up I can do everything I need

Very simple thing but for some reason I can't remember how to do it. When the default menus (ie File, edit. tools, window etc) are hidden away in a form and only a custom toolbar is shown, how do I revert back to having all the defaults. Any help would be greatly appreciated

Is there a way of using a command button on a form to clear the contents of a yes/no column in a table. Any help would be greatly appreciated

I need to create a query so that I can run a report that will show records entered between certain dates. For instance lets say tblTMS has fields IDNo, DateReceived, Name, Address tblWeeks has fields StartDate, EndDate, WeekNo (all dates are in the format dd/mm/yyyy). I want the user to be...