Search results

Thank you. That is exactly what I needed and it worked! Case Closed!

:cool:Minty / all - Thank you for your support and suggestions. The definition of the database is simple; to reduce the amount of time necessary to submit two critical forms. The forms uses repeated information obtained from clients, but this information must be saved in the event of an...

Thank you Minty. I thought I described what I was looking for in an earlier post. Simply put, I have a Master table (Table 1) that contains ID,Name, and birthday. I have created a form to enter data into Table 1. ID is the auto number field, and does not require anything. Once the name and...

Still get Syntax error! See attached screen shot. Why can't access be easier!

Minty - Thank you. I am only trying to make this straight forward and easy, as the next person that comes along may need to make changes. I just want to do this WITHOUT a subform. I want two separate forms. I know the subform is the way to go, but I have my reasons behind this.

Still having problems. Here is my summary: Table1 - ID - auto number Name - Person's name Table2 - ID Select - Needs to be the same as ID in Table 1 Name - Needs to be the same as Name in Table 1 Please advise how the Insert command should look. I only want to copy the last...

When the master record is created, then the program is typically closed until the additional information is known. This is "confirmed" as no additional information will be added into table 1 until table 2 information is entered and confirmed. This is why I do not want to use a subform.

So, something like this? Insert Into Prerelease_info (ID Select) Select Top 1 [ID] From Customer_Info Order By AutoField Desc; I get a Syntax error. I am new at this, so please help.

Thank you. But, I do not want to use a sub form. This is because the second form may not be used for several days, until some of the information is known. So, I want to create the Master record in Table 1, then several hours or days later input the information in Table 2. What I do is open...

I am trying to write an append query that will ONLY append the last record of one table into that of another table. Every time I try this, Access wants to Append all the records. How do you force it to only append the last record?

Well, I tried several different methods last night. Geez this is frustrating! I have no problem using an Append Query, but I want it to only append 1 record (the last record of Table 1). I tried the Insert Command, no luck. Kept getting errors, either format, or syntax errors. So, this has...

The problem is these will be 2 separate tables, performing 2 separate functions. I only used the sample above as an example. The 2nd table in reality will used about 6 things from the first table/form. The reason why I don't want to use a sub form is that the data for table 2 may be inputed at a...

I tried the append route, but there is a chance the 2nd form may have multiple records. This is why I want to do it one at a time. Here is an example of what I want to do. Enter a name, address and say birthday into one table using Form #1. Then close Form 1, and open Form 2. Form 2, will need...

Sorry. Can't post. It's a mess right now. I thought the same thing, as soon as I close the 2nd form, the table would be updated. Not the case. So, how would you do this? I just want to add these 2 or 3 fields, and I'm good to go. The field ID Select is nothing more than a pointer for my search...

Hey, I'd take any suggestions at this point. Yes, all the fields are bound by the table. Just not working, and I can't figure why. Help!!!:banghead:

Okay folks. I know this maybe the wrong place to ask, but I have to start somewhere. I have a table entitled customer info. I have developed a form "Customer Info" in which I enter into this table the customer name, PO number, SO Number, and a bunch of other stuff. When I close the form, and...

Thank you. But, I have done that as well. As said, when I view on the screen and then print, they come out in color. But, when (in VBA) i run the procedure, they come out in B&W.

Hi there. I have searched and searched and cannot seem to get my MS access 2010 reports to print in color. Here is my code: printer.ColorMode DoCmd.OpenReport "Rep Monthly Progress Report", acViewNormal DoCmd.OpenReport "Manrep total sales summary", acViewNormal DoCmd.OpenReport "Region...