Search results

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...

(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...

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...

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...

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...

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...

I would like to employ an unbound Check Box so that when it is checked, all the items in my form (their respective check boxes) are selected (updated to value -1). I would like to do this without using a RunSQL/UPDATE query in fear of getting "Write Conflict" messages left and right. Is this...

I am querying a table in one table/database and using another table in another database to limit my criteria. When I run this without the subquery, it's fine; however when I run this the way it's shown below, it seems to want to take forever. SELECT [clear void date] FROM [tblCleared Comp2]...

I've done some searches prior to posting here, but came up with very little. I am having trouble trying to import a text file into Access. I get the error message "There is no object in this control." When I click OK, a messed-up dialog box comes up and when I click Next > a message comes up...

I have a table that will have data imported to it. Preferably, my primary key will be "ExtractDate", but there will be many items extracted for one day, so I would like an additional primary key "Seq". This seq field could be an AutoNumber field, but it will still continue with its incremental...

I've searched these forums for the Default Value = previous value thing. I've done this before, but I can't seem to remember how...this is what I have on my Exit event: Private Sub Text58_Exit(Cancel As Integer) Text58.DefaultValue = Text58.Value End Sub This works ONLY if my...

Hello all. Basically, whenever a DoCmd.TransferText method is used, I would like to make a backup of the current file by copying it to a file which will be named depending on what the date is. For example, the file detail.txt will be created using the TransferText method, but prior to that, I...

I would like to use a .visible (or the workings of it) on a per-record basis in a form dependant on the value of a combo-box. If "Check" is chosen from the combo-box, I want to display a few things, and if "ACH" is chosen from the combo-box, I want to display other things. Can this be done? I...

I'm trying to use the UCase() function to change my text field on my report to all upper case. The text field has both letters and numbers (such as ph13301). On the report, I want it to display as PH13301. But when I employ the UCase() or UCase$() function, #Error? is printed instead of the...

How does one reference a table in VB code/event procedure? What I want to do is have a Message Box popup when a button is clicked saying that there are no records if a certain table has no rows. (In a previous post, I mentioned that the form would be blank if the control source table had no...

I'm kinda new here, I've been getting into Access primarily for work, and have this database that I'm working to actually use as an export tool to automate some things in my department. I work with Access 97. Anyway, I have a form popup when my "export" button is clicked (through a macro)...