Search results

I have a problem that I think I have a solution to but don’t know how to write the code for it. I have a button that opens a form, on this form there is a combo box that has a query attached to it, the number of records in this query can change and can return no results which is what it is...

thanks everyone for your replies, ive resolved this issue now by use of Docmd.GoToRecord ,, acLast. this did what i wanted

will that work from the button click? also what would that openm a specific form?

Hi all, Im trying to open a form to the last record via a button but cant seem to find the correct command so i currently have sub CmdOpenForm_Click() DoCmd.OpenForm FormName:="FrmEventNewTrackPart", DataMode:= acLastRecord End Sub But that doesnt work can i run a DoCmd.OpenForm...

ive resolved the issues i had, i had the relationship the wrong way round in the tables, Thanks for everyones help

Would you like a relationship report?

i work for a train maintenance company, im attempting to build an asset management database. so table 1, is an event tracker, for events such as planned maintenance, failures, exam work etc. table 2 is the ability to add parts to a specific task, so for example on an exam lighting tubes need...

hey all not used access in a while so im a little rusty, was wondering if someone could point me in th right direction. im trying to create a new entry in a table from an entry in another table Table 1 (TblEvent) Form 1 (FrmEvent_New) Event_ID Date unit_IDFK Vehicle_IDFK NontrackPart_IDFK...

nothing currently, the sub report is unbound i have edited my question regards to the "form" part.

hi is there any way i can display a sub report on a report just one, i have a report with data, that displays the events in continuous format, which is what i want. what i would like to do is display a sub report just once, which shows some totals values, but when i place this sub report on the...

does that use the data from the database, or is that files from the computer, i noticed the file path for the files are computer file paths?

thank you worked a treat

hi im trying to create a sub to be able to email multiple attachments in the same email, i cant use send object as it will only allow one attachment, i want to be able to send a report and a query as an excel format, how can i do this without having to save it on the computer first? the code...

apologies on re-opening this thread again, but how would i be able to filter the data based on data, so i want the lookup to be 14 days, so the failure level will only trigger if its within 14 days if the first event, i thought it would be this SELECT Table_ENG_MCU_Tracker.MCUTracker_ID...

thanks for the advice minty i think i should go for the keep access open option, as some one will always be using it so it'll be open somewhere. i cant use sql express, which is a shame, but the organisation i work for, the IT department as very reluctant to install software such as that, for...

hi i have a sub that exports all tables into an excel spreadsheet, is there any way i can automate this for a specific time of day? here is my code Private Sub btnExportDatabase_Click() Dim td As DAO.TableDef, db As DAO.Database Dim out_file As String out_file = "S:\Systems...

hi i have a function to open file dialog, how can i pre set the folder location heres my code Function selectFile() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.AllowMultiSelect = False fd.Title = "Plase Select The Latest Run in."...

hey all thanks for the help, i decided to use a table in the end, as there was only a few thousand entries for 15 years.

hi all im trying to display all days in a range, i have a chart that shows a running 30 day window, what i want to do is show all days, in that 30 day window, whether an event occurs on a day or not, i have read that the only way to do this is have a table with all dates in the table, is there...