Search results

Hi all, I have a table which have following structure and data in it (Pasting as CSV)... HolRef,CustRef,Resort,Hotel,Type,Out,Home,Cost,Paid SH0001,1,Berlin,Berlin Heights,Full Board,1,2,1400,250 SH0002,2,Douglas,All Seasons,Half Board,7,8,421,170 SH0003,3,Alicante,Sol Melia Grande,All...

Is there any way of opening recordsets as public or global in a form?? E.g. if i do something like Set rs = db.OpenRecordset("TblCustomers", dbOpenSnapshot, dbReadOnly) the variable rs should be available in all the private sub i have on that form, and i should be able to access records...

Can someone please find out what is the syntax error in update query DoCmd.RunSQL ("Update TblPaymentInfo set ([PaymentForVehicle]) = " & txtVehicleRouteCost.Value & " where ([BookingID]) = " & bookID & ";") runtime error '3144'

Is there a way in access, through vba or any other means, which would allow me to either enable or disable criteria in a query based on the value of textbox?? Like i have a query that displays bookings customer has made between two dates, so i made a query and in the starting and ending date...

Hello everyone, I have an access form that displays some data about customers and their booking for flight. so lets say if there is a group of five people that made a booking for a certain flight, i have to assign ticket numbers to them and store it in some table. Now i can display the number...

DoCmd.RunSQL (" Insert into TbBookingCustomerDependent (bookingid, customerid) values ( " & test & " , select ID from TblCustomers where HeadID = " & Me.txtCustomerID.Value & " ") I have two tables TblCustomers & TbBookingCustomerDepended (weird name huh). TblCustomer holds all my customer...

How do i use DMax() function instead of Autonumber, since the table is empty and it wont know what to do with Dmax() + 1 for next record? E.g I have a new table Customer_details which contains customerID customerName Age now if i enter data through forms, i want the CustomerID to be...

Hi everyone, I am currently learning to develop using Access and VBA, and is also working on a project. Now i have a form with couple of textboxes bound to a table. When the user opens the form to enter records, i want to write a function that would go through the textboxes to check whether...