Search results

hold on a sec, i think im actually with you! take a look at the Computers form and Customers form and tell me if that's what you wanted. if it is i'll explain what i did. quite simple actually. -- i realise there's no database attached. i posted before attaching it then i closed the database...

say the text field is 3 charaters long, all 3 charters had to be entered and they all need to be capitals. in the input mask for that field put: >LLL (i think its >, it could be <; i always forget which one)

ok now you've gone and confused me. if upload you database again i will take a look and try and help you out.

make a query, in design view, using all the tables the fields you want to show are in. use the primary key in you main table and then add the fields you want .. so .. [primary key] [analyst name] ... etc. [maintable] [analyst table] ... then have the record source for you sub form as the query.

i doubt this would make a difference but - do you set data entry mode then set the value of customerid or the other way round? i was just thinking you might be changing the customer id for the first record then creating a new record with dataentry = true (or whatever it is)

im no expert but you shouldn't have EmplName or EmplSalary in the LOA table and you shouldn't have the same field as the primary key multiple tables. unless im an idiot, remove the two fields and add a new primary. i dont know what LOA stands for or what it is but may be you could use LOAID...

that depends. do you just want to show records with fields in.. 1)your main table? - yes the sub form is based on you main table or 2)other tables? - no. use a query, selecting the fields you want, and base the sub form on that

well.. for example, just change the txtwhatever to the name of you combo box.value (i think .value im not sure - ive been wrong about it before) ... If checkbox1 = True Then strAnalyst = "[analyst]=""" & cmbanalyst.value & """" End If If checkbox2 = True Then strSystem = "[system]=""" &...

i learnt allot from trial and error. i am doing a course at the moment which involves access and VB - that helped a bit. allot of the time i picked stuff up off the internet or forums; when i couldn't solve something myself i asked for help. to try and answer your other question ... which...

try this: Me.Filter = "[ContactName] like '*' & '" & Text31 & "' & '*'"

just draw a combo box. when the wizard appears select "I will type the values i want". then type the values you want. then select the field you want to store the value in.

off the top of my head you could try a couple things. 1. filter the form onload - if you filter the form by a value you know doesn't and will not exist you will get a blank, new record. 2. don't define a recordsource until the user clicks the "Search" button - you'll have to define a...

why do you want a macro to save a record? the record is automatically saved after each field is updated (right?)

normalisation would be a good idea. off the top of my head i cant figure out what you going to need exactly but i think if you did normalisation you'd get something similar to this (i changed a couple field names so i could get my head around it better): Customer table (Card table) CustomerID...

your right it is searching CompanyName. just change it to: Me.Filter = "[ContactName]=""" & Text31 & """"

if those 4 are fields in the table or query your form is based on the it should work if you just put what you've written into an if; as long as you put the name of each field in square brackets []. so... if [OrderPlaced] = -1 and ... then

try putting the code in the afterupdate sub of event. so... Private Sub EventCombo_AfterUpdate() tboLocation.text = DLookUp("[LocationName]","tblLocation","[LocationID] =" & [EventLocation]) End Sub

yes datasheet view will look like a table. try this: on the form where the user enters criteria: make 7 text and tick boxes - one for each field ... then ... in the onclick event for the button that "searches" put this code (obviously you need to check the names so they match yours) Dim...

what do you want to count? the number of records where A, B, C, D are a specific value?

you end the second if before the else.: ...end if else... change the second bit to: if ... ...datStatusDate Elseif Me.STATUS_DATE.Value = Now() Then 'Inputs the current system date/time End If