Search results

I have a query where I use the search criteria of =Date()+1. However I really need this to add on a working day (i.e. excluding weekends). Is there an easy way to do this?

I have a form with numerous fields on it, with the one I'm concerned about being a date field. I want a different form to open automatically if the above date field is in the past (this will act as a warning to the user). I've created the warning form as a pop-up view but just want to know the...

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

Hi all. I have an option group set up on a form with two options. I want the user to be able to select an option and then click on a command button to run 1 of 2 macros. I thought the code behind the cmdbutton would be simple but i keep getting the runtime error 2502. The code I have used is...

I have a table in MS Access (I've attached a few records for your info in excel format) where I need to exclude certain records. Each record has a number attached to it in the first column (the example shows 1 to 14). In the final column it shows either "Initial Visit" or "Maintenance". The...

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

Is there a way i can use a command button on a form to clear the contents of a yes/no column in a table. I can do this via an update query but I would prefer it if I could do it without getting any propmts warning of the update. 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 advance

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 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 that holds the info on our fleet of company vehicles. One of the fields in the table is called ServiceDueDate. I want to be able to set up a query that shows any vehicles that have a service due in the next 30 days. I know I'll need to use DLookup in there as well as Date - 30...

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

I am developing a database for our fleet of company vehicles. What I'd like to know is is it possible to set up some kind of alert where a dialog box appears (like the sort of thing in Outlook with reminders). What I'd like is, for example, if a vehicle requires a service a pop up would appear...

I think i need to use an append query for this but have never used on before so just need to know if it is the right thing to do. I have two tables [tblPoles] and [tblPoleInstructions]. I have a form set up for [tblPoles] so the user can enter the data required. One piece of data required is a...