Search results

Hi all, I found the solution and wanted to post it here rather than delete the original message in case anyone else had the same problem. After doing some digging, I realized that I needed to get rid of the ID field in the Append table. I did that and it worked perfectly! Tina

I have a "contact" database that needs to be updated on a regular basis with information that I download in .csv format and save into Excel format. I'm trying to expedite the transfer of data from the spreadsheet to my database so I don't have to enter each contact individually (which is how...

Are you looking to return specific records based on "and" criteria or "or" criteria? I'll try to help by giving an example, though. Let's say you sell greeting cards and you were looking to return all orders inputted after a certain date and associated with a specific town (or state). If you...

I have a database that needs to be available to other people via a network drive and I've made the dBase "read-only." My problem: Currently, the users can open the input form via the menu (it's an "Edit Data" type selection but they can't change any data) so that they can view individual...

Actually, it worked when I put the following in the default value of the ClientID properties on the Policy Form =[Forms]![Add/Edit Client Form]![ClientID] Thanks for the assistance!

Thanks for the response -- unfortunately, it's not working! I put the expression in the Before Update of the PolicyForm form properties. Is it because I'm using a linked form instead of a sub-form, maybe?

Hi all, I have an application I'm working on with separate tables for clientiand policies. The policy table is linked back to the client table via clientid (one client to many policies). The client info comes up in one form and the user can then click on a command button to open the linked...

Rich, I actually went back and deleted all of the buttons, then added a new "OpenForm" button. I still get the same error (AddNew). I also went and checked the code as you suggested and, sure enough, it goes right to Private Sub AddNew_Click(). This is the code I get when I click on the...

I went and checked out the other message you recommended and then went and looked at the database again. The problem seems to be that when I click on a button, it sees it only as AddNew and not as anything else. If I click on Close Form, I get the error message and the debugger pops up...

I used the form wizard to make a form from a parameter query. It worked great and I was really excited because this will be invaluable for the semester project I'm doing. I then put a command button on a form previously created (using the wizard) that should open the new form (and thus request...

Okay, I've decided to change things just a bit from my above scenario to make things MUCH easier. Rather than hinge the ID on the type of equipment AND the unit, I just want to base it on the unit. In other words . . . The number assigned would be the 2-letter abbreviation for the unit plus...

I'm currently designing, on paper, an application that I'm trying to develop to track events. I can't give specifics but will try to elaborate a little. To give more detail, I'll have options similar to the following in my main menu {sub-menus contained in brackets would show up as a new menu...

Ahhhh . . . I see now! Thanks for the help! I did the 2 locations I had info for manually already (tedious but necessary). I'll try this on my next location.

I have a report that has a blank page after every page that has data on it. How do I get rid of the blank page?! Also, how do I get the report to repeat column headings on each page? It only puts the column headings before each grouping. My problem is, each grouping has several pages and I...

I'm using Access 2000. I was unable to find OnExit Even in the Form Properties box. Has it changed between Access 97 and 2000? One of my boxes is a combo box already. With 26 locations, you can see that it would get tiring scrolling down and looking for the particular location I'm working...

I'm pretty sure this has been covered before but, of course, now I can't find it. I'm using Access 2000. I need to input "inventory" for several locations, one location at a time. How do I set the form up so that, until I change the location in the location box, it stays the same as the last...

Okay, I got the first column in the combo box hidden and I built the combo box from a table rather than inputting the values myself (which is how I did it the first time). Interestingly enough, I'm getting a different error now when I tab past the ShipName entry on the form. Here's my event...

Jack, I tried your suggestion; it didn't work. I got the following error when I tried to enter a new event: The expression After Update you entered as the event property setting produced the following error: The object doesn't contain the Automation object "Me." *The expression may not...

Thanks you, Jack! I'll give that a try this morning. To give more info for my second question: I guess I'll need to run an event that will, when a component serial number is entered, go to the corresponding table and look up the lot number and other info and return it to the form and to the...

Okay, here is what I want to do: I have form that requires input of a ship name and number. I'd like the number field to fill in automatically based on the ship name that the user inputs into the ship name field. To that end, I developed a table that contains each ship and its associated...