If i have an .mdb that is reliant on a security workgroup, can i have another .mdb that relies on the ms default workgroup running at the same time?
If so, how do i go about doing it please?
i have attached a .mdb because i have a feeling i am not going to explain my problem very well.
When the form opens, i want a new record to be the focus and not the 1st record in the table.
Any ideas please?
I have an AutoNumber field in a table that starts at 1 but I want it to start at 8251 as it continues on from an existing application, is this possible to do please?
i have a system (win2k) with office 2k installed but this system needs to use a database only compatible with office 97. i have tried to uninstall office 2k and re-install office 97 but i get errors with access saying there is no licence.
The database can't be converted due to its poor...
i have entered a Tab Control on my form and have put a label on page 1.
on page 2 i have put another label but when i go back to page 1 it has the 2 labels on top of each other
hoe can i make each label only appear on the page it is originally placed on please?
i have a report that is populated from a query but when the report opens it shows no data.
if i run the query it works fine
the criteria for the query uses the selection from a combobox on a form
[forms]![formname]![comboname]
Can anyone tell me why please?
i have a ComboBox that looks for a record on my form but when i select a customer it gives me a no record error but when i display the form in design view and then change back to form view, the records are diplayed and it works fine
I only get the error when i first open the form
Any ideas please?
I am trying to put access levels on my database and was wondering if it is feasible to have a table with user names with an access level between 1 and 5 assigned to each user?
If so what would be the best way to go about it please?
Password Form
I have the following code
Private Sub cmdOK_Click()
'On Error GoTo Err_cmdOK_Click
If IsNull(Me.TxtName) Or Me.TxtName = "" Then
MsgBox "You must enter a User Name.", vbCritical, "User Name Required"
Me.TxtName.SetFocus
Exit Sub
End If
If...
I have an Admin area in my database and want to be accessed only if the correct user name and password is entered.
Can someone please give me some idea of where to start please?
I'm not too good at VBA so the more help, the better
I have a database on a new machine that is not part of the same workgroup as the rest of the machines and when i open the database it wont let me access it. Is there a way that i can login as administrator so that i can inport the data into a new database?
I need help!!!!!!
I have upgraded from 97 to xp (office) and now my database doesn't work.
I have tried to convert it but it has got conversion errors.
if I try to add fields to my table, it won't let me save
Any ideas please?
Hyperlinks !! URGENT !!
HEEELLLLLLLLLLLLLPPP !!!
I have a field in a table containing absolute hyperlink references to files on our server. I have just installed a new server with a different name so the hyperlinks point to the wrong place. I have about ten thousand links. Is there a way i...
I have a Macro that opens a report in TwoPagePreview that works fine so long as there is data to show.
In the no data event of the report is another Macro that opens an ok/cancel type of form.
The problem is when there is no data the run command in the macro still trys to open the report in...
my report can sometimes be quite long and i would like it so that when a user clicks the print icon, it only prints the 2 pages on display (TwoPagePreview) instead of the entire report.
Can anyone help please?
If you are feeling very helpful, I am still trying to get the report to open in...
I think I must be having a blonde moment!
i have a form and on it, a combo box with two options (Yes or No)
When i select yes, it shows as -1 and when i select No it shows as 0
Can someone please tell me where im going wrong?
i have a form and on this form i have a textbox labeled "Authorised By:"
i want the text box passworded so that the name entered into it must relate to a password to stop unauthorised people trying to put their name in the field.
Is this easy to do?
Is there a better way of doing it