Search results

Thank you ruralguy, I will take a look at it. I tried doing it like the access help says to but it wouldnt work. Many Thanks!

I can not make the link thing work, and now I cannot even make it work with the images being stored in the database. My DB is very simple, and I am attaching it, along with my Images folder and a couple images. If ANYONE can figure out my problem and suggest how to fix it I would greatly...

AWESOME! Thank you a bunch!

OK, I have 3 fields in my table: First Name (FNAME), Middle Name (MNAME), and Last Name (LNAME). The table is named EMPLOYEES and I need to make an expression that will give me an employees full name (LNAME, FNAME MNAME) in that structure. Now I created a new Query which included the three...

I know everyone is going to say DONT PUT IMAGES IN YOUR DB< PUT LINKS TO THEM IN! I am not at liberty to change the structure of what my boss wants, he wants the images stored in the DB so that is what I am giving him. My problem is this: I have a single form for entering data into my Table...

I have my form where each records image displays as you scroll through the records. I want to add a control similar to the file dialog control, where users can browse to an image file on their machine, and then preview it and Update it. Can anyone walk me thru how to do this?

I actually just got it to work, by making the filter a variable rather than trying to use the Me.Number. Dim criteria As String criteria = "[Number]=" & "'" & Me![Number] & "'" and changing my command at the end to: DoCmd.OpenForm "Special Housing Unit Inmate Data Entry", , , criteria That...

YES! The number is Unique on the current table, and is what I tried to use to filter the records so only the new record would show, by using the command below. DoCmd.OpenForm "Special Customer Data Entry", , , Number = Me.Number But it does not work, it does not filter out any records at all...

Even under the assumption that I use the same table, the necessity here is that one form lists normal customers/inmates and a second form lists the special/history form. So the root problem remains the same, when I copy the special/history back into the normal table, I want to swap to the other...

Guys, I was using Customer and Special Customer as examples, I figured it would be easier to understand with that example, rather than me explaining my two tables here. My Database in reality is in a Prison Setting, and is used in a Special Housing Unit. When an Inmate enters we have to enter...

I would look into cross-tab queries, that is a good way to monitor a total on running values. Once you get a query that will search for the right record, and give you the total hours, simply create your form to include your table and your query. Use the controls you need to edit data on your...

Are you trying to copy the record to the SAME Table or a new table? If it is the same table, simply use the Command Button wizard. Just be careful to not copy the Primary Key in the process, that will cause an error due to duplicate values. If you still get the error, using the above...

OK, I will give this a try. After your 3 tables are completed, set the relationships, and make sure to use referential integrity and cascade the update. I doubt you want to cascade the deletes. After that use the wizard to create a form. Add ALL fields from ALL 3 tables to the form. On the...

I have code for a button click event. Essentially I have a main table form that I use to enter customer data and info. I also have a button that I use to add that customer to a separate table that I use for special Customers. My code copies all the data I need copied to my other table, so I wont...

Hi, I will try to describe exactly what I need to do and what I need the report to do. I have a report which has to match the same format of an approved form. One problem I have is one section/field which is best described as a free form input from a user, like a notes section. The section...

Thank you. That list of references is IMMENSE! Are there others that I should include?

Pat, this code worked in my Tester DB, which used the exact same structure, but when I tried to use it in my real database, it gave me a compile error on the 2 Dim's. The error was: User-defined type not defined. It triggers from both of the Dim statements. It also highlights the "dbs As...

AWESOME PAT! I have been trying to get it to work for several days, asking for help on several forums, and was at the point where a guy gave me three times that amount of code, to do it a lot harder. This is absolutely what I needed, and I GREATLY appreciate you being so understanding and...

I'm having the same problem, it lets me enter as much as I want with the scroll bar on in the form... but as soon as I TAB out of that field, it cuts off all of the data entered that took over 255 characters. Mine are Bound and I have the can grow settings on for my form and report, as well as...

That will not work for me, I actually have over 50 fields in my main table, and only want to copy 7 to my history table. The names of the fields however are exact matches. I want it to addnew when the user deletes a record from the main form, so I have been puttting the sub into the on delete...