Search results

dcx693: That works. I just attached the code to a checkbox instead of a command button...HOWEVER...This only works for one record. I need to be able to select checkboxes in ALL records (my form is displayed as "Continuous Forms").

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

The data in the other database table is always being changed/updated. If I link that table as opposed to accessing it through a query only, how will that benefit in processing if it still needs to obtain a current "snapshot" of the data inside?

I can join two tables from different databases? I had trouble doing that so that's why i used the subquery. I'll have to try it again. Thanks!

Instead of deleting this thread, I'll offer my own solution for archival and search purposes. The subquery should be run against a table, not a query! It speeds up the process!

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

Ok, I can either create a new database, or use an existing one, and in the Database window, I'll go to New when in the Tables section, I choose Import Table. I am then prompted to choose a file. I will change my Files of Type to *.txt, *.csv, *.tab, *.asc, and choose the text file. The text...

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'm going to go ahead and just compare what I want to do with how our DB2 tables work...Some tables have 7 primary keys, where 5 of them are sequence numbers, being unique within it's higher sequence number, and repeat when a new higher sequence number is achieved. Sounds like VBA must be used...

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

That also works, but still only for numerics, nothing with text will work

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

I'm not sure if that was the answer he was looking for. If it was, then great; if not then here you go. You need to attach your subroutines to events such as OnClick, or Before Update. I could be missing some things though. If you are executing your code through forms, then you can see these...

And you coded the whole thing out for me! Thank you very much. You are a big help. Now this opens new ideas on file handling within Access for me.

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

By the way, I redesigned the thing, I'm using a "single form" layout instead of continous, so I am now using the .visible attribute. Are you sure you want to know what EPD stands for? "Elderly People Driving", but that was years ago when I made that up. I had made a speech in speech class in...

Ok, nevermind...I had to change the control source on the form itself to the name of the query. Thanks for your help!

Well, I thought about it, and this may be the better idea as it's easier to handle...just one textbox to handle this "additional information"....but my problem is I created the text box on my original form to mimic your text box that grabs "ShowField" from the query, but it's giving me a #Name...

Not sure what you're asking, but if I understand corretly, I would prefer to have both types of records displayed at the same time. Take a look at the attachment. Thanks for your help

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