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...

Exactly what i thought.

In addition to opening recordsets, i would also like this function to perform some checks whether the table contains specific data or not. Scenario is, i have a form with about 4-5 buttons and each button on click, the system has to access one table to ensure there is data in table before...

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...

Yup, parentheses did it for me.

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 this correct for the starting date, gave me an error of expression typed incorrectly or too complex to be evaluated. >=Nz(CDate([Forms]![FrmDisplayReportBookingDates]![txtStartingDate]),1\1\2015)

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...

Got it It should have only select, not values keyword DoCmd.RunSQL ("Insert into TblBookingCustomerDependent (bookingid, customerid) select " & test & ", Tblcustomers.ID from TblCustomers where HeadID = " & Me.txtCustomerID.Value & ";") This query will insert multiple records in...

I guess that is the problem, there are multiple values or records i want this insert query to insert and there are multiple records. How do i do that??

Yes HeadId is a number. Ok i tried your way and now it gives me the following error 'Runtime error 3067 Query input must contain at least one table or query

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...

Thanks, it worked.

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...

Thanks guys for the response. So lets say i want this function to execute on some button click, i just write (type) the function name in that sub, right??

Is there a way to use a loop to go through all the textboxes, no matter how many are there in a particular form (to check for Null or empty values)?

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...