Search results

I've had the same exact problem before: Go to the table where the field is located. Go to the design view. Make sure you change the data type from ANY type of integer to decimal, and specify the number of decimals you'd like That will fix the problem. Cheers, Bachfile

Hello again! I am doing an "Updates" form which has name, time, date and updates done fields so that updates/changes to the database are recorded on a regular basis. I have removed the navigation bar and instead of having a separate record for each update, I wanted to append or add to a locked...

Thanks a million Pat! Works perfectly now! This will save a lot of time trying to find a record! Cheers, Bachfile

Ok Pat, I got around the stupid wizard and entered everything correctly, but it still doesn't work. It looks up the accession numbers fine, but when I select one it gives the following error message: "Data type mismatch in criteria expression" Here's the code that it is referring to: Private...

Thanks for the advice Pat. I will definitely look into that. In the meantime I was wondering how you would go about creating a lookup combo box without using the Access Wizard? If you could help me out on that one that would be great! Thanks, Bachfile

Hi Sorrells, The problem I had was with the one to many relationship that I had between the two tables I was using to get these two combo boxes synchronized. I had a one to many relationship, but I couldn't enforce referential integrity because the data types were different (long integer and...

Thanks a lot, Peter, I can get everything I need now. Bachfile

Do any of you wizards of Access have a clue how I would go about creating a form for adding notes of what was updated to the database every day? I've seen one before where you type in the day's updates in a text box, press a button and it pasted it to another text box that was locked and you...

Just a simple question - how do you get into a form's properties? I keep getting the properties for the form's detail section or form header section, but never the actual form properties where I can add new fields to my form. Thanks, Bachfile

I am constructing a database for a small museum. I've got two main forms - one for entering a donor of an artifact collection's name and one for entering detailed information about each artifact in a collection. The donor form has input for the donor's name, address and phone number and has a...

Thanks a heck of a lot guys! I figured it out FINALLY!! All the code was fine, it was just the relationship between the two tables that was the problem and I was able to fix that. As soon as that was fixed it started spitting out the correct subcategories! Thanks for all the help guys!

Hello again, I keep having a problem Enforcing Referential Integrity which allows Cascade Update on two tables. The "One" table is a Category table with fields CategoryID (autonum) and CategoryName (text). The "Many" table is a SubCategory table with fields SubCategoryID (autonum)...

Thanks a lot for the code! Unfortunately, I try it out, and everything seems to work fine except that no entries are showing up in the SubCategory (your Attraction) combo box to select. Is there any way I could send you my form + the two tables zipped up? I could really use some outside help on...

I searching for the threads but none came up that gave instructions on creating cascading combo boxes. Do you mind explaining that for me? That would be great, thanks. Bachfile

Hi, I have two combo boxes that use similar information for this museum database that I have just started (but its working finally) To catalogue the artifacts for this museum I have many descriptive areas, including the object's category and subcategory. A category would be personal objects...

I will look for those, Pat. Forgive me for my lack of Access knowledge, but how would I get to these options on the form or are they commands that I would have to use in the Visual Basic code area? Thanks a lot for your help! I really appreciate it! Bachfile

Thanks for the suggestion, Pat. I will look at that. I remember already looking in the properties for the query and the recordset was not set at snapshot - it was set for the other one, I can't remember what it exactly was and it didn't do anything. I would go into the form and I wouldn't be...

I tried the idea of the query joining the two tables and then basing a new form based on the query and it works to a certian extent - it showed the donor name, address and phone number but when I try to enter any other data on the form, it says "recordset cannot be updated" - how can I change...

Thanks for the suggestions. Just one more thing. I really don't want to create a new form. Is there any way to alter the control sources to read the record of the donor's address and phone number from the other table, or is that impossible without doing this query stuff? Just curious. I am...

Hi, I am designing a database for a small museum with the purpose of cataloguing all of the artifacts in the museum using hard-copy records. I've got two main forms to enter the data - one form to enter a donor, their name, address and phone number and another to enter all of the information for...