Search results

Hey, I have a form which has a command button to run two queries...one to update the labour cost from the hours worked field and one to then update the total cost by adding the labour cost to parts cost. These queries work fine and it updates the table fine however, it doesn't display the...

Hi, I have a report which displays an invoice for each customer and at the top it says the date of the work carried out...however, when a customer shows that they have had work carried out on more than one occasion, the invoice still only shows the date of the first record...is there anyway to...

The list box gets its values from a table at the minute, it displays the Customer Forename, Surname and Address and another list box displays the Mechanic forename and surname. I want to be able to enter appointments for a specific customer, and select the mechanic from the list box...is this...

Should I make access save the data in the list box to a seperate table or should I let it store the values for use later? If it stores the values, how do I recall them? I would like it to put in a new appointment in the table in order to facilitate the use of timetables...should I just use an...

Hi, I am trying to get access to first pick the customer from one list box and then pick the mechanic to assign the job to from another list box...I can't work out what the button i need for it to save a new job under the date is for this command! I would like it to be able to assign a job for...

Hi, I am editing the design of a census, and I would like to be able to mail merge form the query directly to a new document in microsoft word...so you can create the document and then merge to it, is this possible using a macro or VBA? I can't work out how to do it!! The query name is "List of...

Unfortunately this does not seem to work, if i attach the database to the post...will someone have a look at it? It is in the frmBook that I wish this argument to work, so that when Village Party Allowed is ticked, the tick box for village party becomes active, is there anyway anyone can do this...

Hi, I have a field in a form that says when you are able to book a certain event, and i want the field in which the event can be booked, to remain unable to be edited until the tick box says yes. Is that possible? Chris

The formula WeekdayName(Weekday([MyDateField])) works like it should, however it is wrong! It tells me that the 21st January is a Sunday however it is infact a Saturday! Is there any reason this is wrong...and any way it can be fixed?! Cheers Chris

Hi, My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it...