Search results

It is numeric so your example "WHERE Users.ID= " & strUserID worked like a champ. Many Thanks! :)

Carl_R, Currently, I am using code to publish my data to a report, save it as html, launch the file with iexplorer and asking the user to click the iexplorer Mail button which launches Notes 5 with the html file in the body. If you have a better method I could make good use of it, would you...

I have a table nameed Users whose Primary Key is a AutoNumber field named UserID and a boolean field named LoggedIn4 that tracks wheter the user is logged in to the application. I want to log the user off when they exit the application using the following code, but I either get a data type...

Solved I found that txtboxes with a default value of a date (05/04/05) displays 12/30/1899 unless the default date value is inclosed in double quotes. The solution was to inclose the txtbox.DefaultValue in " 's using the string """", like this: txtEst_Comp_Date.DefaultValue = """" &...

Can I bother you with a follow up question? Hey Dugantrain, can I impose on you one more time? After successfully setting the default percentage, I went to add code to set a default value for two other fields using the code below. It sets the default percentage with no trouble, but the...

Final Solution You were right Dugantrain! Thanks for all your help. Here is the code that finally worked. Private Sub Form_Open(Cancel As Integer) Dim sqlPercent As String sqlPercent = "SELECT TOP 1 PE_ConstReport.Percent_Compl " & _ "FROM PE_ConstProjects LEFT JOIN...

Thanks for your help Dugantrain! It makes sence to me. I'll give it a try first thing in the morning.

Hi, I have a form used to create a new record. I would like to make data supplied by the user in a previous session the default value. I am strugling. Here is what I have so far: Dim lastPercent As Variant Dim sqlPercent As String sqlPercent = "SELECT TOP 1 PE_ConstReport.Percent_Compl" & _...

Many Thanks Travis! It worked great. The "Debug.Print strSQL" helped my find another mistake - I changed my CurRec declaration to point to the control that holds the primary key. (Da!) CurrentRecord just returned 2 if I selected the second record in the subform and 3 for the third, etc...

Hi, Thanks for your help! I have a Function that is intended to toggle a boolean field in a subforms recordset. If call the function with the commented SQL with a descrete record number, it works perfectly, but does not when I use the declared variable. Is Long the wrong data type for an...

Hi Pantscat, I am working on the same problem with limited success. I started by creating an unbound "hilite" control with it's visable attribute set to No and placed behind my bound control. I created a macro to Open the report, then set of a the value of the visable attribute to Yes on...

I am using MSAccess97. I have a dB in production that is collecting status reports into a memo field from a form control. I need to export this data to a comma delimited file to import into another platform. The memo field is full of "double quotes" ;) and they are corrupting the data by...