Search results

Hi Adam, That dosent seem to be working do i need to edit it in any way

Hello i currently have the following code for searching for records in my form, can anyone help me adabt it so that i dont need to type the EXACT data as in the record eg if im searching for name i have to put Julliet where i want to be able to search on just julli and it will still find the...

Thanks a lot ill try that now

Sorry could you please explain a little deeper as i am still picking all this stuff up what parameter do i need to change? thanks a lot

Thanks, will that open the report to the record i am currently viewing

Hello, what i am trying to achieve is when i click a button in my form it loads my report up and selects the record i am currently viewing and prints the report for that record. thanks a lot

Hi, Please be patient with me as i am still picking up the ropes in access, what im trying to do is if i click a link in one form to open a different form in the same database, the record i was in on the first form is the same that appears on the second. Hope you understand what i mean, thanks

Thanks For Your Reply, Sorry to sound thick but what are bookmarks and how to add them in word to link to my database, thanks

Hi, Please Be patient with me as i am new to access and still learning the ropes. what im trying to do is create my database so that when i click a button on my form say named "print invoice" it opens a standard letter and enters the details of the current record i have opened into the relevant...

ok thanks would you mind doing an example with the code i posted before so i know what i should be putting exacly thanks

sorry here is the code i already have: Me.Cardnum = Left(Me.Text12, 16) Me.Expirydate = Mid(Me.Text12, 17, 4) Me.Startdate = Right(Me.Text12, 4) this is the data i want to spiit it is in a text box named Text12: ;6767094116363345=10072010000003757170? i want that split in a form in access please...

thank you i am quite new to access so could you please give me a more step by step answer and just to clarafy i want this to work in a form thanks

hello last week i asked for some code to seperate datafrom one field into three new fields i had some code posted which works great it was: Me.Cardnum = Left(Me.Text12, 16) Me.Expirydate = Mid(Me.Text12, 17, 4) Me.Startdate = Right(Me.Text12, 4) please could you add to this and tell me how i...

numeric long inteager

yeah i just put fieldname + Fieldname

hello i have a small problem please can anybody help: i have tried to make an expression to add two numeric fields up in a form but instead of adding up like 1 + 0 = 1 it adds up 1+0 =10 anybody know how to fix this thanks

i still can get it to work i keep getting synax error and i dont really understand what the controll name is

i tried: DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName i dont really understand the field name and controlname bit either would you mind explaining it a bit better and give me some examples thanks a lot

ok sorry i have one form with some customers infomation on it eg- First Name, Surname, Customer ID ETC... what i want to do is when i click a button to open up a second form to show extra details of the customer eg - Address, Telephone number ETC for the record on the second form to be the same...

sorry i cant get this to work can you give any other ideas thanks