Search results

I have a button on my form that should open a report in Preview node. On SOME users machines, it appears that absolutely NOTHING happens when the user clicks the button. (preview mode) Report parameters that may have some bearing are as follows. (Default settings in most cases) Default View ...

Hi there I have implemented both methods to send an email from my form, but it seems that there are subtle differences. It seems that 'objMailItem.Send', creates and sends the message 'silently' (no confirmation from the user is required), whereas the 'DoCmd.SendObject' method requires the user...

Hi Dave Its A Simple Update Query. (bkgdate = Bkgdate +1) I Was Asking The User For A Start And End Date, And Then Append Each Day From Start To End. But It Seems That Namliam Has Set Me On The Right Track. It Looks Like I Will Have A Solution Shortly.

Thanks for your assistance namliam I think that I will pursue the path of booking by period, however, I cannot bypass the booking by 'guest' as (to quote george orwell) 'some pigs are better than others' and I need a way to deal with them.

Hi Mailman I like where you're going with this, but think that there are some practicalities that are forcing me into a record per house/room/date scenario. I was hoping that by giving only the relevant info in my first post, would simply solve the query refresh issue, but I i am now tempted to...

This Is A Good Question Which I Have Previously Dismissed As Being Impractical For The Following Reasons. Our Organisation Has 12 Houses In Remote Communities. Each House Has Up To 3 Rooms. Most Rooms Sleep 2 People, But Some Could House 6 People (in Sleeping Bags) If Neccesary. Genrally, A...

Hi there I am making a booking system where a user enters StartDate, EndDate (Form Header) House , Room , UserID (Form Footer) The Header and footer are not linked. The Footer simply displays all the existing bookings for said House/Room/Date combination. (Date being all dates between the...

Hi John I see that your 'Supply Receipt' is sourcing its data from a query that is being run on the form, but you have already saved the query (called 'Supply Receipt Query'). When you save the query, it is referred to as a stored query. This greatly enhances the performance of the DB and (I...

Well Done!

OK - This is the last comment I intend to make on this as I am now convinced this is a MS bug. If I run the following MAKE TABLE query from code, the output is NOT corrupt. strSQL = "select A_TimeSlots.ID, A_TimeSlots.StartTime, A_TimeSlots.EndTime, '" & _...

Just another note - On each of your forms, you might want to set the 'Record Selectors' property to 'no'.

No Problem. Edit the Material/Supply field to include both the Manufacturer and supplier as follows. On the Data tab, in the 'Row Source' property, put this code. (You could have changed it graphically but it might take a little longer for me to explain.) SELECT DISTINCT [Material...

OK - So now Iv'e done a little more testing. Tbl_TimeSlot consists of ID (AutoNumber), StartTime, EndTime To do this, I have done the following. Create a query that selects all the TimeSlots >= Tbl_TimeSlot.ID (This works fine) Now I tried to add a calculated field that puts in the VehicleID...

I Have created a new DB as suggested and imported all the objects that I need. Still getting the same problem. NOTE: It seems like the text corruption is ONLY displaying in query results.

Hi Gramps Did you find a solution to this? I'm in the same boat. I dare not think that MS have not thought about this and made a solution. I just gotta find what its called.

Thanks Rural Guy I am aware that MS stores date/time fields as 'one' - My problem is that I dont know how to display the field (Calendar with time options) to the user so that they can book a car from 2:30 PM to 4:00 PM on 1-may-2014. As for the characters problem, I have changed the way that I...

Make A Query That Displays Your 3 Fields. In The Combos Data Source Property, Point It To Your Query.

Do You Have 2 Fields With The Same Name. The Prefix Identifies Which Field (TABLE/QUERY) The Data Is Being Sourced From.

Put A you combo box In The Header Section Of The Parent Form. I Assume That Each Form Is Based On A Query? If So, Make The Queries Filter On The Combo Box. Now Simply Refresh Each Query When The Combo Is Updated.

Hi all Using access 2010 2 questions in one here. I have a form where users can book a vehicle. In order to ensure that the vehicle is not double booked, i need to run a query that compared the existing data in a table to the data in the (dirty) booking form. Data being checked is: VehRego...