Search results for query: *

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

The table I want to run the query on has a date in the format of dd/mm/yyyy. I want to be able to run a query so that the user can type in a month and all records with dates in that month will be shown. I have done this before many years ago but now have a mental block and cant figure it out...

Hi guys, can someone please point me in the right direction I'm sure there will be a way, but I cant think of it, that you can extract data from an excel spreadsheet and update/append records in an MS Access database using VBA code. Any help would be gretaly appreciated. Thanking you in...

Thanks for your reply. The problem I have with it though is that I cant create a new worksheet each time. Basically what I need to do is take data from my database, send it out to external companies, let them update the worksheet and send it back (and hopefully import the updated info back...

Hi all, any help would be greatly appreciated. I need to be able to take the data from a query and export it to an excel spreadsheet that is in a set format (the format can be anything as not decided yet). I know how to export a full record to excel but I need to be able to to export it so...

Hi all, Is it possible to create a query that looks over two different databases for information. i.e I have two departments at work that have seperate databases and I need to be able to search for data in both of them on the same query. Any help would be greatly appreciated.