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 "dog"
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 ""
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.