Search results for query: *

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

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

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

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

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

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.

I have a spreadhseet that shows some materials we use in our company. The first column shows a description of the material, the second column shows the catalogue number of the material and the third column is left open for the user to enter in the required quantity. I have attached to the...

I have set up an input box for a password that opens a report using the following code: Private Sub Report_Open(Cancel As Integer) Dim PW As String PW = InputBox("Please enter the password") If PW = "THECORRECTPASSWORD" Then Else MsgBox "The password you entered is not correct" Cancel = True...

I have a form that uses a query as its control source. The problem I have is that on this form I have an unbound textbox that I need to show the result of another query in. I thought I could do this by using =[Query]![QueryName]![Field name] in its control source, but this isn't working. What...

In one of my tables I have a Yes/No field that users click if a job has been Issued [chkIssued] and a number field to show the week number (can be 1 - 52) that it was sent out [intIssuedWeek]. There is also a Yes/No field for when then job has been completed [chkCompleted] and a number field for...

I have a table in a word document and I would like one of the columns to have a check box in it. I know how to set this up but there are other columns on the table that I still want to be able to edit data into. The way I know how to put the check box in is by using the forms toolbar and...

I am working on a database to hold the data regarding our company vehicles. I have a table for the details of the vehicle (i.e Registration, VehicleType, Drivername etc) and a number of tables for different types of equipment (AccessEquipment, LiftingEquipment, StandardEquipment and others). I...

I have a set of command buttons on a form that open up a series of reports. The problem I have is that only certain users should have access to particular reports and I want to be able to put some kind of password protection in. If anyone knows how to do this please let me know. Thanks