Search results

Will Do! Thanks!

Perfect! Thanks so much! I have one final question and I will be done with this database. On the Repayments form, I would like to create a way for a user to: 1. First search the repayments table by the OP Number (for example: 1111) using a combo box 2. Then, using a second combo box, select...

Works perfectly now! Thank you so much! On a separate note, do you have any recommendations on how I can reorder the combo box info in ascending order?:

Thanks John! I am starting to get a feel for how this works. I still have one problem - the form/table will not save. I did exactly what you instructed, but when I modify the record (maybe change the first name, for example), I can't leave the record, and it won't save. Any suggestions? Thanks!

John, I tried what you suggested, but I got the following error: Here is design view: Do I have to put "Last_Update" in brackets, like this: Me.[tbl_Overpayments]![Last Update] = Now() ? Thanks!

I attached the file I am working on. Check out these three forms (in the Forms section): frm_Overpayments frm_Repayments frm_Write_Offs The tables linked to them are under the Key Tables section: tbl_Overpayments tbl_Repayments tbl_Write_Offs Basically, I want this field to auto-update if...

Beetle: Yes, I will try to post some more information (and maybe a cleaned-up version of the Access file) later on. Thanks so much!

Beetle, I tried just that (created a macro in my table - before change - and saved it) and my Last Update field is not changing still (the field is blank no matter what, even if I modify a field in the record. Not sure where to go. What information can I provide so I can get help?

Hi! Here is my issue: 1. My goal is to have a time stamp which will update if a record in a table is modified or created. 2. I want that time stamp to show up on the user form (but not for editing, just for vieweing). 3. I tried to follow these instructions (using Access 2010)...

Perfect! Thanks for the quick help!

Hi! I am trying to fix a combo box to remove decimals. Here is the info: 1. The combo box is used to search records in a form. It is linked directly to a table. A field called "OP" is the item that needs to be searched. "OP" is a four-digit number. 2. Here is the "OP" field's properties...

Update: I sort of fixed it, but now the problem is that when I use the tab button to go from one box to the next, it skips the Last Name field until the very end. How can I change this?

Hi! I used the form wizard to create a form which can be used for basic data entry. My problem: Some fields that the wizard created are not text fields (such as Last Name), and Access will not let me change to text box. When I go into Design View and right click the list box --> Change To...

Thanks Beetle! I created a one-field, one-record query table and linked it to the form. Works now!

Hi! Here is my idea/issue: 1. I have created query that has the following expression/field: Days Outstanding: [Reporting Date] - [Table1].[Filing Date] 2. [Filing Date] is contained in a [Table1] of course. But [Reporting Date] is not in any table. I guess it is a query parameter. 3. I...

Perfect! Thanks a lot! These basic bits of information are helping me learn effectively!

Wait. I just realized one problem: I didn't include the ID field. Therefore my table appears as follows (using my original example): Amount, CountOfAmount 1, 1 2, 1 3, 1 4, 2 The problem is that I need the ID field included. But if I include the ID field and select Group By, the...

Hi John! Thanks for the link. I actually tried this but failed to realize I had grouped by the primary key in my query. Got to start somewhere! Appreciate it!

Hi! Basically, here is my situation. I have a table with the following fields: ID Amount Here is a sample table: ID, Amount A, 1 B, 2 C, 3 D, 4 E, 4 I want to create a query with a new field called "CountOfAmount". I need this field to count the number of occurrences of "Amount". For...

I see! Got it! I actually learned a ton just from these basic instructions you provided. New to programming, so thanks again!