Search results

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

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

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

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

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

hello does anybody know how to do the follwoing: when i click a link of one form to open up a new one how can i have it automaticly direct me to the record i was looking at on the first form hope you understand and please explain in steps as i am quite new to VB coding thanks

Hello, is there anyway in a access form to set a kind of "IF" formula for example if the yes/no box in one field is set to yes then that changes the data in another field. hope you understand thanks

hello, is there a way in access of telling you if there is another identical record to the one you have just entered eg- if i enter a model number in the model number field of: 11004 if there is already a record with that model number it gives me a warning message or stops me entering the data...

Hello, I need some simple code to be able to position by form when i click a button so eg set the width, height, left properties ETC... Any Ideas Thanks

Hello does anybody have any code for centering a form i know about the autocenter property but i want it to center on command thanks.

Hello i am new to access so please explain things step by step in my form i would like a search bar in the body of my form that allows me to search by first name and click search and i can then see my data in the form i know about the search feature on the button but i really need one built...

hello i am new to access so please could you explain things step by step: what i would like to do is have access click in a field in my form when the form opens up so basicly on the on open propertie does anybody have any code for that thanks

Hello i am new to access so please explain things step by step, thanks i would like my form to open up full screen and cover the taskbar thank you.

hello i am fairly new to access and i dont know much code but i do know the basics of how to add code and how to navigate the properties bar, i would like some code or a way of copying one piece of data from one field into another field inside a form i would like it to copy over when you click a...

Hello i am quite new to access i have been using it for a couple of months now and am getting the hang of it i dont know any VB code but i know all about how to put code in and how to use the properties window (i am using access 2007) what i want to do is as follows: 1. i have a magnetic card...