Search results

I dont think a new back-end database is needed. I created the workgroup file with the valid users that will be using my database. When you say "the admin user must be deleted", I can't do this as "Admin" is required in the access security file. (This is where, in Access, you would go to...

I am in need of some assistance regarding SQL Server ODBC links and security. This is for a project at work... 1) I have an MDB that has linked tables through ODBC to a SQL Server 2000 database. This is how I chose to write this multi-user application (instead of the ADP method). 2) My IT...

I'm surprised no one replied to this one... After thinking about what I was asking, this is an Access Command. I load the window by using: Application.RunCommand acCmdUserAndGroupAccounts

(Resolved) Load User and Group Accounts Window using VBA I know there are ways to utilize the ADO Extentions (ADOX) to maintain users and groups using VBA. But I feel this is already maintained in the form provided by Microsoft (User and Group Accounts) and that it is enough for a user to...

Is it possible to suppress a page from generating upon print/preview based on the value of a calculated control (text box)? This calculation is based on other controls in the report and sits a group footer section. I looked into reading the recordsource, but it isn't as straight-forward, so I...

When an error is encountered during the execution of a module, on error I am handling it by displaying the Err.Number with the Err.Description and Err.Source on a message box. However, for me, the programmer, I would like to know which line the error was encountered on. Is there an object...

You can use the NAME function. This File I/O function performs file renaming and moving. Name "C:\folder\file.txt" As "C:\folder\newname.txt" Changing the destination of the second filename will perform the move/rename at the same time.

Can you develop a separate database apart from what the users are working on, and when you are done, you can roll it out to staff?

I'm not familiar with binding an access application. What could it be bound to? Anyhow, most of my forms have queries. Those queries are saved as objects and some are brought into the Form_Open event due to dynamic criteria. However, I am doing a SELECT * in those queries. Would being...

I have split a database--a front-end on the user's PC, and the back-end on a network drive. For me, like others, performance has suffered. I have researched issues on various websites on how to alleviate some of this and found that the use of domain/database functions slows everything down...

On the handler, could you say: cmdDelete_ClickError: If Err.Number = 6 Then 'Enter your custom code here if you want specific operations to occur here. Else msgbox Err.Number & ": " & Err.Description, 16, "Error" End If Exit Sub

For the obvious reasons, I'd like to perform inserts within a transaction so that referential integrity is maintained. However, I am still getting Key Violation errors when doing TransferText methods within a transaction. My relationships are setup between the related tables ELMDTL and ELMRSP...

Okay, I'll index them. I'm curious to see how many records will start to bog down performance without the indexing. It'll be two fields...my filter is [UpdateUser] IS NULL AND [DTS] IS NULL. They aren't the primary keys though.

The number of records in the tables will be continuing increasing through a daily import. The subform(s) will filter/display a decreasing percentage (probably about 20-40 records that users will update). Regardless, when I make the determination as to whether to move to queries for the...

I have 2 sub-forms housed in a main "parent" form for display purposes. They are unbound to the parent form. The sub-form record sources are tables, and these tables will get appended 20-70 records per day through an automated import process. However, when the subforms are opened with the...

Actually, I'm not coordinating any data between the form and the sub-forms, which is why I have them unbound. I am using the parent form to hold the two sub-forms (two record sources) so that they can be displayed side-by-side.

Thank you for your clear and concise answer. It has helped me greatly and I can now use and share this technique in the future!

I have two subforms displayed at the same time within one parent form (they are unbound). In both subforms, I have drop-down combo boxes to change the record source of the respective form (through VBA). What I would like to do is when an item in the combo box in any of the subforms is selected...

Thanks. I put the REFRESH in there to refresh the form display so that it'll display the records with their new current values.

I think i has the solution! This is on my SELECT ALL checkbox. DoCmd.SetWarnings False If Me.Check46 = -1 Then DoCmd.RunSQL "UPDATE tbl_Master_Compass ..." ElseIf Me.Check46 = 0 Then DoCmd.RunSQL "UPDATE tbl_Master_Compass ..." End If DoCmd.SetWarnings True...