Search results for query: *

That's the weird thing. When I click the button to open the Survey form it does open with the correct attendeeid showing in the attendeeid field. But it leaves the attendeeid field blank in the table.

Thanks for replying. The code below is the query behind my survey form. SELECT SatisfactionSurvey.SurveyID, SatisfactionSurvey.AttendeeID, SatisfactionSurvey.Session, SatisfactionSurvey.Question1, SatisfactionSurvey.Question2, SatisfactionSurvey.Question3, SatisfactionSurvey.Question4...

I have a very simple database. Client table connects one-to-many to attendee table and Attendee table has a one-to-many relationship with Survey table. Client is the main form (single form) with Attendee as the subform (continuous form). I'd like to put a button on the detail row so when you...

Sorry it took me so long to respond. I was trying the ideas above but still not working. Originally, this did work for me but I was storing the name of the city in the city field instead of the autonumber which is what I need to store for the record. I changed the fields accordingly. Now when I...

I have one table, City, that contains an autonumber field called AddressID. The other fields in that table are text and are City, Township, County, Zip and State. I have 2 combo boxes I'd like to cascade. The first combo box is cboZip, which is text. The info for it comes from the City table...

That worked! Thanks. You are correct. The name of the tab is ctlProgram.

Definitely confusing. I can provide you with a screen shot which might make it a little clearer. NavForm

Thanks.

Thanks for the suggestion but it didn't work. My tab control name is Program and it is equal to 1. The navigation form has been killing me, but it's all done except for the tweaking such as go to next record.

Hi All! I have a Horizontal Tab Navigation Form. I can get the main form, Client, to open to a new record when the database is opened with no problem. Client has a tabbed subform, Programs, which is setup as a continuous form. Whenever they click on the Programs tab, I'd like it to open to a...

ContactID and PhysicalLocation are both defined as numbers in my database. PHVs code did solve my problem. If someone with text is having the same issue, they can now find the answer on this tek-tip, too.

Thanks so much. I was sure I'd have some user(s) clicking on the blank field and didn't want them to get the debug window.

Hi All! I have the following code in the on double click event: Private Sub cboPhyLocation_DblClick(Cancel As Integer) Dim frm As Form, rst As Recordset DoCmd.OpenForm "Contact Info" DoEvents Set frm = Forms![Contact Info] Set rst = frm.RecordsetClone If rst.BOF Then MsgBox "No Records!" Else...

Yeah! Thanks so very much. I never even thought of using the OnEnter event. It works absolutely perfectly. :)

I have 3 tabbed forms. First tab is Client which is the main form. Second tab is Program which is a subform of Cient. Third tab is Changes which is also a subform of Client. I choose a client and can easily click any tab and all the data is filtered for that particular client. Change the client...

I'd like to use the new Horizontal Tabs 2 level navigation form for a new database but am having problems getting it to work. And maybe it won't work the way I'd like. I have a table, ClientInfo, with a primary key of ClientID. A Program table with ClientID as the foreign key and ProgramID as...

It does help. Thanks.

I need the Premium add-on for terminal services to support remote desktop. I realize that I'll need one set of CALS for the 2011 Standard and another set of licenses for the Premium Add-On. They will be residing on the same server. Does anyone know if the CALS for Premium Add-On cover Remote...

I need the add-on for terminal services to support remote desktop. I realize that I'll need one set of CALS for the 2011 Standard and another set of licenses for the Premium Add-On. They will be residing on the same server. Does anyone know if the CALS for Premium Add-On cover Remote Desktop...

Both Office 2003, Office 2007, and Office 2010 can save files as .doc and .rtf files. If you're uploading them to a web browser for people to view, I'd save them as a .pdf file. The x at the end (such as .docx) does not mean they are zip files that you would need winzip or the like to open. They...