Search results for query: *

I can't figure why my workbook won't freeze panes at A2 so that my column headers are always showing in a scroll. Everything else works. Here's the whole code: Private Sub cmdExport_Click() On Error Resume Next Dim xlApp As Excel.Application Dim xlSheet As Excel.Worksheet Dim...

After inserting records from Oracle into a table in Access I want a msgbox to display the count of records inserted. I thought this would work and it doesn't, what am I doing wrong? daily_count = "SELECT Count(tblDaily.VENDOR_NAME) AS Count From tblDaily" MsgBox "Daily table import has...

I want to be able to add some code that gets run every time someone uses the embedded "go to next record" navigation arrow at the bottom of the form, is that possible? When users add some notes to an unbounded text box on the form the text will stay in each record they navigate to until the...

I have a form that opens data in another form. But if I enter data that isn't in the database, it doesn't do anything, so I want a msgbox telling the user that they entered a case number that isn't in the database. Maybe a dlookup, I'm not sure? Here's the code so far...

I have a field in a table I pass notes to set to "Allow Zero Length" = No, and I'd like to keep it that way but I'd like to have the run time error window not pop up everytime someone tries to enter a null value, but have a msgbox pop up telling them to enter a note. Can I do this? I'm new to...

How can I prevent a NULL from being passed in this simple cmd button so that a msgbox pops up telling the user the enter a value? *************** Private Sub CmdOpenForm_Click() Dim rs As DAO.Recordset Set rs = Forms!frmMainEntry.RecordsetClone rs.FindFirst "CaseNumber=" &...

I have created a seperate form that comes up from a button off of my main form which is based off of a query with parameters that can find a record in the database. But now I'd like the ability to have them just click on a button that will open that record in my main form and then close itself...