Search results

anyone know?

Hey guys, I have a Macro that exports a table to a db that works fine. Is it possible to have the Macro enter a password to the message box and press enter automatically?

Heh, yeah, I just used a right join and it works now. Thanks!

Hey guys, I have a table with 50 records and another table with 10 records. The table qith 10 records correspond to 10 of the records in the larger table. How do I make a query to show all 50 records, but include the extra fields from the 10 records where applicable? They way my query runs only...

Hey guys, I'm creating a sub form which would have a couple common fields from another table. This form will be used for data entry. Is there a function that someone can show me so that when the user enters in a specific detail, the other fields will populate with the corresponding data? Let me...

Hey guys, I want to learn how to make a form that a user can fill out on my webpage and update it to the database. When I create a Page within Access, I cannot update any of the fields. Is there a property I have to check off? everything is a default right now.

Thanks, theprez. What I'm curious about is whether or not it is dumb to share the same primary key across all tables. In this sense, I might as well just keep them together, but since they are in their own categories, I would like to separte them. Is it out of the relational design to keep...

Hey guys, If I change the startup properties to not show full menus, how do I get around that to be able to see them again?

Hey guys, I'm creating a database based on an Excel file. The Excel file has about 180 columns and are only linked by to distinct fields. Is there any possible way that I can break this down into easier to manage tables? There are different categories of columns such as Financial Info Personal...

Hey guys, I'm looking to update two fields based on another field through a form. Basically a user will enter a number into Site_Key on a form. I would like two other fields to be updated to this number as soon as they do it or click on another field. Can someone help me with a macro for this...

I have a large number of fields, is there a way that I don't have to type every single thing out? I'm putting old fields from a few tables into one table called ARCHIVE

Hey guys, I'm trying to move a group of fields to a new table. I want the data to follow it. Is there an easy way to do this?

Thanks, those are some really good examples. Now, is there a way I can link the computer name to the person's name through a table lookup? I'm using this code, and not too sure how to interpret it 'will show all user's currently being connected to a database ' '* based on information...

I know this is a really old thread, but great work Hayley! I am curious to know how to hide the DB view fromthe user while they are logging in. I am still able to play with the tables and whatnot while the login screen loses its focus. Is there setting I have to check off?

Hey guys, I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can 1) Kick a user off 2) Send them a message 3) Send a...

Are there any exceptions to this? How about an alternative? I would like to have the medium date format, but also allow a TBD.

Hey guys, I'm not sure how to do this, and I can't find any info about it, but is it possible to set a value for my date field to accept either 1) date 2) "TBD" 3) null Is there a way to allow and exception of "TBD"?

Yeah, just finished reading all the results. Looks like it's not possible to read the login ID's of other users :(

This is the snippet of code taken from Whoson. It returns the Machine name, but I'd like to have the login ID called.

Hey guys, I downloaded a function that can list what users are logged onto an MDB file by machine name. Is there a way to convert it to show the computer login ID? Here is the snippet of code Open sPath For Binary Access Read Shared As iLDBFile iLOF = LOF(iLDBFile) Do While Not...