Search results

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.

Thanks I've sorted this now

Thanks for this

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've done this now except for getting the numbers to roll over. Any ideas?

Thanks RuralGuy I've done it now

I've decided to put this unbound textbox on as a subform. What I'd like to be able to reference the text box on the sub form as part of a calculation in the control source of an unbound textbox on the main form. is this possible?

I'm trying to produce a report that will show how many jobs are still outstanding with uncompleted jobs rolling onto the next week. An Example of the possible format would be ..............No of Issued Jobs.........No of completed jobs.......Jobs Outstanding Week...

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

Thanks Crispy

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

Could you let me know the easiest way to get around this by detecting the network ID

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

Thanks I've figured this out now

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