Search results

That worked however Like '*" & [forms]![search bookings]![customername] & "*' needed to Like "*" & [forms]![search bookings]![customername] & "*" with the double speech marks

I have create a query that get its criteria froma form entry with the code below. [forms]![search bookings]![customername] However this does not allow the use of wildwards when typed in the form as it shows no records. e.g. *Acme* IS there anyway that my code can be change of the use of a...

I would like to set the form to open on a blank form as though to enter a new record but for the user to use the scroll buttons to search past records. I have tried setting the Data Entry property to yes but i cannot scroll through past records. Can any one help? Thanks

Im sorry and i dont want to waste your time or sound stupid but i went into the design view of the query and could not see 'code builder'. I have a report that picks up the data from that query and therefore need to put the function in the query. Unless someone can think of a better idea for it...

HOw can i insert the function a query, i can see any command to be able to do that.

How can i set the criteria to of a query to be the value of a global variable i have created. THanks

Superb thank you

Hi i tried that already but without any luck here is the SQL code of my query so far: SELECT dbo_tblOpCusts.Country, Count(dbo_tblOpCusts.Country) AS CountOfCountry, dbo_tblOpRotation.ArrDate FROM dbo_tblOpCusts INNER JOIN dbo_tblOpRotation ON dbo_tblOpCusts.CustID = dbo_tblOpRotation.CustID...

Hi I would like a query where i would like to see all the records within a certain date range and the do a count on a field. However when i run this query it shows me all the records on each day if there was a record for that day. It would then count how many records were on that day. however i...

i have a gv set called vlevel i would like to set an on open code that if vlevel is defaultuser then certain items on the form will not be shown and in instead other details are i have tried the following but cant get it to work. select case vlevel case "default user" credit details.visible...

I have created a report that has everything i need and layout. however when i try to send it as an email via an rtf or html document it loses it formatting. Eg. the lines i have drawn the logo and the tick boxes for fields. does anyone know how i can email the report so that it doesnt lose any...

How can i export the contents of a form or report to an email so that someone can fill in the relevant details but the recipient cant change the formatting. Can anyone help

i tried it Hi I didnt really understand what you said so i tried a different way. i created a query with all the relevant fields in. in the id number of the record for that form under criteria i wrote: [forms]![book]![Booking Reference] I then create a report based on this query. in the form...

I need some help in printing a report from a form that the person has just a filled in. The print this record button doesnt work as i only prints what you see in that form and as i have tabs on my form it wont print all of it. I thought about after the form had been filled in and the print...

Hi i have create a log in using the security wizard. this opens up a main form. How can i out a buton on the main form so that the user can logoff and logon as a different user. also i have created groups with the database and wondered depending on which group the user belongs to if i can open...

Hi DBL Could i also have a copy please as i am also working on something that sounds very similar. Thanks BC

that works. Thanks

I have created a form and have got all the controls i want on it, but i would also like to different tab screens because there is too much info on the one screen. can anyone give me some step by step to add in tab pages on the form. i tried just drawing the tabs from the toolbox but cant seem to...

Hi im trying to get my dlookup code to work but can get it to. I have create a blank form with a username and password box i have a table called staff in it i have a column called staff password and staffusername and issales(yes/no) my code is as follows but gives me an error on the dlookup...

I have created an unbound form and put in place two unbound toggle buttons labeled current & not current if a user selects either toggle then the relevant data is shown. So if current toggle is selected and the user clicks on the button to show the data it will check the table to see if the...