Search results

I am trying to make an MDE file but each time i run the option i get the following error appear. CompileError In Hidden Module Form_FrmUsersLogon any ideas what the problem could be, if you want i can paste the code from wherever required. Cheers Andy

I need to open a specific document from my pc on the click of a button, can anyone tell me the best way of doing this please. patch name for the file is: C:\Documents and Settings\AndyS\Desktop\Oee Database Changes.pdf cheers Andy

I have a form which is set up as a security logon form, what i want to do is add a button so that when an unregistered user clicks on it it will open up outlook in order for them to email me to ask for a username and password. I would need my email address to appear in the to box each time they...

i knew i would be back.... here is the sql of query 1 - called top 10_Zone1 and query 2 - called top 10_Zone2 top 10_Zone1 SELECT TOP 10 copy_eventcodespecific.MajorStop, copy_eventcodespecific.Line, copy_eventcodespecific.EventCode, copy_eventcodespecific.DayCode, tblMachines.Zone FROM...

i really appreciate your help, will have a look and see what mess i come up with.....will post again if(When) i have any problems Thanks Again Andy

now there will be a first.........never used a union query before, but will have a look..........do they work in the same manner as a normal query ???

ok thanks i got that now............. to take this one step further..... is it possible for me to do the following: each line is in a specific Zone, eg lines A & B are in zone 1 Lines C & D are in Zone 2 and so on can i run the same type of query but pick the top 10 from each zone, so i...

Hi Thanks again for the help.. this is the sql currently in place... SELECT tblEvents.DayCode, tblEvents.Line, tblEvents.EventCode, tblEvents.MinorStop, tblEvents.MajorStop, tblEvents.Breakdowns, [MinorStop]+[MajorStop]+[Breakdowns]+[CIP]+[ProductChange]+[Maintenance] AS total FROM tblEvents...

I have generated a query which the data is then displayed in a report.....the trouble is that i am dealing with approximatly 1000 records per day.... I am trying to display just the top 10 event for a specific day. so for example: Line A had 500 minutes downtime Line B had 475 minutes etc...

columns.........i just tried your previos option and it deleted all the rows, so glad your back

I have just set up a macro to import some info from Excel, all works well, but i keep getting 4 blank columns on theend of my data, is there a simple way that i can remove these columns, within my macro or by using a delete query

i have 2 tables set up as follows, Table 1 Employee Number - (PK) Forename Surname Coach - Checkbox (and a few other but these are the main ones) Table 2 Employee Number - (PK) Forename Surname Coach - Checkbox Trainer - checkbox (and a few others) Table 1 is where the bulk of the employee...

i have two tables, in one of the fields of table 1 i am trying to lookup from table 2 a list of names, the headings are Table 1 ID Forename Surname Table 2 Date Trained By - this i need to display forename and surname When i do this it displays the forename and surname in the drop down...

thank you very much....i will have a look. The problem is though that i struggle when it come to adding it into my database. Cheers Andy

i have over the past few months been tryiing to get my head around the code behind access....... i have struggled to self teach myself what very little i know, however i was wondering if anybody could point me to some form of literature that can explain what the code is doing. for example what...

hmmmmm......thanks but not 100% that thats what i am after i need to know when any changes have been made to the system. Ideally without people knowing that i can check this info

also meant to mention that the following code is behind on double click function on a text box: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Form_BeforeUpdate_Err Call Audit_Trail Form_BeforeUpdate_Exit: Exit Sub Form_BeforeUpdate_Err: MsgBox...

i dare say that this is a topic that has been tackled 100's of times before, and although spending hours sifting through the search files i really am none the wiser. i have inserted an Audit trail into my current database to try and track who is playing with the figures the way i have done it...

Thank You

the code works great but when i click ok on the messgae box it goes on to the next box, ideaaly i would like it to remain in the current box untill the correct data has been entered. Can this be done please, if so how ?? Andy