Search results for query: *

I am looking for a function that takes a date of birth and returns the persons age someone must have already written a function for this!

the users to an access databace only prevent other users from accessing the data if the db is open exclusively the problem was the iuser account privolages we had a second problem with IIS, it had been changed to ver6 we set it to act as IIS ver 5

I have a web site that varifies login taking the user name and password from an access database when a database user has a data object open the login on the website dosn't work when there are no users in the database the login works I have checked exclusive shared propertys within the...

I want to change the printer that a report prints to as it prints or just before. depending on the user that is logged in at the time. I can copy the report and print the required version but it would be much nicer if I could just change the printer from code.

create a form with Fields (Suburb, xType, Price1, Price2) the fields can be combos, listbox or text box add a listbox called SearchResults configure the columns etc add a comand button called search which calls the procedure below or call it from afterupdate events Private Sub...

add another feild to the table store an integer 1,2,3,4,5... then add one to this number to track the increment and only add the next main increment when you hit your max value and reset the new field back to 1 or 0

try a routine like this cut and paste into a vb or vba editor for some colour Private Sub SetSearchResults() Dim strSQL As String strSQL = "" Dim haswhere As Boolean haswhere = False strSQL = "SELECT SentFaxes.ID, SentFaxes.RefNo AS [Fax Ref No], SentFaxes.CompanyTo AS...

here is an example of how we build sql strings and set the results in a listbox (its the same for a sub form control sourse) Private Sub SetSearchResults() Dim strSQL As String strSQL = "" strSQL = "SELECT * FROM SurveyDetails WHERE ((JobID) =" & dlgSurvey.JobID &...

Try 'declration public sub x(y as string) 'Call x &quot;dog&quot; you may need to put your public procedures into a global modual and edit the referances Me. will be replaced be Forms!<formnName>!form!<ControlName>

Use the master child links in the subform propertys set child = box1; list1; box2; list2 set master = field1; field2; field3; field4 try it with one combo or list then add the others in turn if you are setting these from code first set them to &quot;&quot;

Create a local variable set the variable move record (acNext) then copy the value to the field from the variable

sorry that should be DoCmd.GoToRecord , , acNewRec

if the current main record is a deleted record then you will get that msg when tyring to add a sub record try Me.refresh or Me.requery OR move to a new record (DoCmd.GoToRecord , , acNext) at the end