Search results

Gasman, yes that is the exact one!

The_Doc_Man, I totally understand your reservations on giving guidance on how to remove password protection from a database. However my instance is somewhat different. I have stupidly imported an Access form from a zip file, posted by wardster on this forum. This imported form has now effected...

Ranman, thanks for your reply. Password protection wasn't turned on and still isn't. The only thing that changed was the addition of the form in the zip file to my database. this then created the password form every time I open a database file.

Hoping someone can help with this one! In an attempt to add security to a database I am building, I have added the file in the attachment to my database, without reading all the replies, now every time I open any Access database on my Pc I am asked for a password, because of this file. Let this...

Thanks to everyone for taking the time to look into this and replying. I feel it may take me some time to get to grips with this puzzle. June7, you are totally correct about using spaces and reserved words, this I am only finding out as I go along as I am still very new to Access Many thanks again

so you would expect more than 5000 records to take quite a long time then

Hi, I have changed the tables so that they are now saved as normal tables not linked and have assigned an id to each record in both tables, in the hope it might speed things up. However wheelwearcalc is extremely slow to load. Any guidance on how I can achieve the calculation I describes...

plog, I have followed your instructions, pasted your code into a new query, wheelwearcalc1, which works fine. I have then created another query, wheelwearcalc2, and linked the 2 fields. however in design view when I drag any field from either query into the design grid and run the query I get...

plog, to be honest, I'm not sure where to go with this. I have put your code into the main query: SELECT [09ts data].[Axle Location], [09ts data].Date, [09ts data].KM, kmnow2.kmnow, [09ts data].[ave pre wd], [09ts data].[ave post wd] FROM [09ts data] INNER JOIN kmnow2 ON [09ts data].[short no] =...

Sorry, I'm not familiar with subqueries. Will have a go making it work with your code

plog, many thanks for your input. Can you please tell me what fields I am to include in the new query, as I am totally in the dark! Thanks

Thanks Uncle Gizmo, unfortunately I haven't made any progress with the link you provided. I am thinking about tackling it another way. By creating another that Dsums the [ave pre wd] and [ave post wd] by group and then do the calculations. Im not sure it will work but I cant see another way. So...

I don't know if this is possible, I'm hoping someone can help! I have a query which lists train wheel diameters and I need to calculate the wheel wear per kilometer, to predict the life of a particular wheel. Attached is a portion of the query put into Excel, hopefully this explains what I'm...

almahmood, thanks for taking the time to produce the code, it has given the results I was after.:)

The data is stored in a linked spreadsheet, so cannot be altered. in the spreadsheet the columns are titled 01x02, 03x04 up to 93x94. In the query they are named as 02:01x02, 04:03x04, etc. to give a field named 02, 04, 06 etc. each field name represents a different numerical value. The first...

I have a query, AccumaltiveKmnow, that is based on a linked table AccumaltiveKM. The query gives me the kilometres [km] on todays date for units numbered 02,04 06 up to 94. Accumaltive KMnowdaynow0204060804/05/2017760622714839.598851542891303 see attachment for the query. Is it possible to...

riddders, thanks for your reply. below is the code I've used; Private Sub print_Click() DoCmd.OpenReport "annual_leave_form", acViewPreview, "", "", acNormal DoCmd.PrintOut acPrintAll, , , , Me.quantity DoCmd.close acReport, "annual_leave_form" End Sub

Morning all, I'm hoping someone out there can help. I am trying to print multiple copies of a report called "annual leave" from a button on a form called "annual leave form". I need to be able to print multiple copies of the report based on the value the user enters into a text box which is...

CJ_London That has solved the problem, many thanks for your help.

this is the code Private Sub Form_Open(Cancel As Integer) Dim I As Integer cboSundays.RowSource = "" For I = 1 To 10 cboSundays.RowSource = cboSundays.RowSource & Date - Weekday(Date) + 1 + (I * 7) & ";" Next I End Sub