Search results

Now I'm getting type mismatch error 13 I also tried CInt(AddReqNo) but same result

The ID is the RequestID I just renamed it and it is an auto number type When I make it this way Private Sub Command12_Click() Dim AddReqNo As String AddReqNo = InputBox("Please enter the Request No. from your email", "Request No. Entry") DoCmd.OpenForm "Frm_AirTravel", acNormal, , "RequestID="...

Good day all, I have a table where the ID is an auto number type. I have a form with an "on click event" for a cmd bttn and the following code: Private Sub Command12_Click() Dim AddReqNo As String AddReqNo = InputBox("Please enter the Request No. from your email", "Request No. Entry")...

I tried that and it wasn't working so I just deleted the list box and redid it Also I had to change the rowsouce from table/query to Value list in the properties Thank you

Hello, I have the following Code: Private Sub grpRprt_AfterUpdate() With lstOptions Select Case grpRprt Case 1 .RowSourceType = "Table/Query" .RowSource = "Qry_StatesTest" .Enabled = True .Value = "" Case 2 .RowSourceType = "Table/Query"...

Thank you for your help! I have a better understanding of it

WOW! That was exactly it. I have a whole empty record that I didn't see but basically Const SQL As String = _ "SELECT UserLogin FROM Qry_User WHERE UserLogin Is Not Null" With CurrentDb.OpenRecordset(SQL) Would handle the issue in the future? Correct?

Hello very smart people, I have the following code: Option Compare Database Option Explicit Dim db As DAO.Database Dim rs As Recordset Private Sub Form_Load() Set db = CurrentDb Set rs = db.OpenRecordset("Qry_User", dbOpenDynaset, dbSeeChanges) Do Until rs.EOF...

I found a way to do it in VBA but is there a way to remove the paint color behind the text? When I go back to Form view, the word is showing white behind its own background. I guess this is where I have an issue. By the way, this is an unbound text field Thank you,

I entered "Please enter User ID" in the Default Value property under the data tab with I still don't see it when I go to form view?

Good day all, I've created a login form for my access database and I was wondering, How can I place the instruction in to a Text Box accompanied by an icon For example: In my userID text box, I would like it show "UserID" or "Enter your UserID" where it's grayed out on the white background...

Thank you very much for all the help. Everything is working here :)

Just the word "Certificate"

Correct Mark, It has the full path and file name.

Nevermind...I was making it difficult for myself. I had the code on the wrong field. But anybody knows how I can change the name of the field in the report instead of it showing the file path? Thank you so much for all the help

The Report Data source is that Query, also originally I went to the tools Group then chose Hyperlink, I then went to the hyperlink builder and chose that Query for the Cert field so this is what is showing on the Hyperlink Builder - Base URL: =[Qry_Training/Certifications-Active]![Cert] Was I...

Thank you All for your help. It works, the MsgBox/pdf are now showing BUT then I get these error messages: The object doesn't Contain the Automation object 'Qry_Training/Certifications-Active.' You tried to run a Visual Basic procedure to set a property or method for an object. However, the...

Good day Smart People, Can someone please look at this code and tell me what I'm doing wrong? I'm getting error code 94: Invalid use of Null Private Sub Label93_Click() Dim Hyperlink As String If IsNull(Hyperlink) Then MsgBox "No Certificate Available" DoCmd.Close Exit Sub End If If Not...

So I have Form A, Form B, Form C I open Form B from Form A and 4 values carry over. 1 value from Form C also carries into form B the value from Form C is an unbound text field I've created that has a Sum() expression that calculates several vales within that From C. But when I opened Form B...

It is a Sum() of controls on that form So do you mean, create another unbound field and make it equal to the previous one?