Search results

ByteMyzer, thank you for the advice. I have added that EOF check. pbaldy, Like I said, I am new to Recordset and Looping. Can you explain what you mean? Thank you both for responding!

Hello everyone. I am new to Recordsets and Looping. I will try to explain this as best as I can. I have a table with two columns, Phone Numbers and Drivers Times: CellExt DriverTime 3335551234@vtext.com Louden 5:30 3335551234@vtext.com Garner 2:00 3335551234@vtext.com Wells 5:00...

Thank you all for your help.

I have a txt box on a form that the user types a message into. But there needs to be a maximum of 150 characters in the text box. I am trying to create another text box that shows how many characters are left as the user types in the message. Text36 is the box where I want to show the...

Thank you, that worked perfectly.

The Form is bound to a different table. I'm not sure how bind a field to a different table.

Is there a way of linking an Unbound Text Box to a field in a table? The Form already has a different Control Source and the Table only has one Field with one value in it, but that value can change. I just want to pull that value into the Unbound Text Box when the Form loads, but can't seem to...

Ok. Thank you.

Thank you for the thought, but the problem with that solution is that the form is stuck in one position and can't be moved around.

Hello all, Is there a way of removing the top menu bar of a popup form? I know I could set the border to none, but I still want the thin border all around the form, just not the top title bar. Thank you

Thank you for your help!

Hello all! I am trying to have access email a report to a group of people every 15 minutes. Between 10a and 4p. This is not a daily thing. It will only be needed 2 or 3 times a year. I could use windows scheduler but if possible, I would rather have just have the database open on an computer...

Yeah, I would normally do that as well, but it is a front end/back end setup and the front end people are out in the field and it runs real slow, so I need them to update before heading out.

Will that work for tables in two different databases?

No, the tables are linked at all. Just two different tables. I just want to be able to append the data from one to the other with the click of a button. SQL is fine. I'm just not sure how.

Hello all, I am trying to append data from a table in one database to a table in another database using vba. Can someone point me in the right direction. Thanks!

Thanks again! I'll keep trying things and if I come up with something I'll let you know.

Thanks again for your help, but the reports are still only putting the first record in each report and not moving to the second record. It is creating the correct names for the .pdf files though. If you open the files you created, does the data on the reports change?

Oh, here is the sql for qryPreRegBarcode_pdf SELECT tblPreReg.PreRegCode, tblPreReg.Cust_No, tblPreReg.Cust_Name, tblPreReg.Cust_Addr1, tblPreReg.Cust_Addr2, tblPreReg.Cust_City, tblPreReg.Cust_State, tblPreReg.Cust_Zip, tblPreReg.Cust_Phone, tblPreReg.Cust_EMail, [Cust_FName] & " " &...

Ok, jdraw, tried putting the "!" in front of [CustName] and it now creates the individual .pdf files correctly named, but the actually data on the report is the same for all of the files. It is the first persons data. That isn't changing.