Search results for query: *

I still can't understand why the simplest things are the hardest for me to find. I can find things like list inversion, sorting, Martian characters, ad nauseum, but not anything about how to change the list used to populate a listbox. I have gone through tutorials and tips and found nothing...

Hi all, I have a text box on a userform that I’m trying to use for both display of a cell from the sheet and as an input back to the cell. The problem is that the cell formatted as Time (13:30). I’ve tried different formats with same results. The textbox displays the TimeSerial instead of the...

Hi all, I've got a form with an Option group and simple selection: Select Case fraEEPicks.Value Case 0 MsgBox "Please select a reporting form." Case 1 DoCmd.OpenForm "Claims Analyst" Case 2 DoCmd.OpenForm "Provider File Analyst" Case 3...

Hi all, I'm sure this is a newbie question, but I can't find an answer no matter where I look . I have several forms and I'd like to put the same exact subform (copy) on each of them. When I try to copy and paste the subform, the subform on the original form becomes a blank space holder. I...

Hi all, The subject says it all. This may be a very simple question, but so am I. Are all Access databases designed to run in the main Access Window? Is there no way to make a database look "professional", instead of something written in another program? This may be trivial to most of...

Hi all, I've got a subform on a form. This subform is identical in every way that I can think of to another subform that works, but when I try to enter data, the textbox reverts to a zero. The other subform in the other form works just fine. I've looked at the properties of the form and...

Hi Folks, I have a form bound to Table1 and a subform in it bound to Table3. When I click on the SUBMIT button, I get 2 records added in Table1 and 1 record in Table3. Table3 data seems OK. In Table1 the first record created has all the data fields filled, but not the name, date and...

Hi folks, Things were going reasonably well, until some of my users starting bumping into this error. When they open a database, they get a thermometer window that says Installing: Microsoft Office Access Feature. They never saw that before. The program seems to open OK, but click on any...

I can't believe how helpful you folks are and how dumb I can be. I have a subform, bound to a table, with data entry property set to yes, because I want blank fields to start. There is no record recall/display, only data entry. The subform has 6 fields. When I tab from one field to another...

Hi folks, You've all been wondeful in helping me and now I have another newbie type question. I have 2 tables that I have related thru the ID field. When I put the data in my form and subform, the ID is not saved into the new record of the second table. It is in the new record on the first...

Hi, I've got a couple of forms that are used for data Entry only. When a user enters the form, he is presented with blank fields. After filling the form, the user presses SUBMIT, the new record is written and the user is taken to a menu. My question is if the user presses CANCEL and he is taken...

I've got a form with bound and unbound controls, text and numeric. What I'd like to do is have my user come in and see all blank boxes. If he fills the boxes (only 2 required out of 20) then hits CONTINUE command button, I want that saved as a new record. I think listing all the boxes and a...

Hi all, I think the subject says it. I have two people working on one MDB, sometimes at the same time. We've already lost some time becase of miscommunication. Is there a way to allow them to work on it at the same time (shared, as in excel)or some way to lock the other one out when one is...

Hi all, I just got done messing around with my mdb and tried to save it. Of course I got the backup question and I put the file on my Thumb drive. Then I saved it again with the regular file name. I copied the file to the server. Now not one of these files will let me do anything. Right clicking...

Whenever I start my MDB named "Claims Prod", with a title of "Analyst Input" I get a pop-up message that says: The form name "Analyst Input 1" is mispelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and...

Hi, I'm trying to create a very "mild" security startup form. The form consists only of Username and Password fields, with Submit and Exit command buttons. What I'm trying to do is have the Username be the first initial & last name of a user, and the password to be the last 6 digits of a...