Search results for query: *

Wow PHV - your xlApp. suggestion seems to be working - everytime you respond it's golden...thank you both.

Well I'm doing all this code in Access, not in Excel, thats why I stated Compact and Repair. I'll change the code back to the way you suggest. I guess the problem lies with Excel and not Access, and I didn't know Excel had it's little repair thing like Access does. I might try that as well...

I've tried that one already and it did not work. I did however compact and repair, and my same code worked! So I tried it again, and it did NOT work. So I compacted and repaired again, and it did NOT work, so I tried a 3rd time, and it DID work. What is going on?

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...

you da man pwise...

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'm having a hard time justifying reading this rather then finding some code that I REALLY need right now, but I have to say that philosophy is always bound to the limits of language, not thought, and the bible says that God's knowledge has made mankinds knowledge absurd (definately you have all...

I have a note table that is linked to the main form where the case number is via case number. But in order to have a one to many I just insert the max note id + 1 and insert the current case number at the same time. Here is the code. Function AddNotes() Dim SqlAddNote As Variant Dim...

Allow Edits = Yes Yes it is updatable I have it unbound so that I can pass the notes to a tbl that houses only the notesid, notes, windows user name, and timestamp where any form can pull the notes data into itself.

Same error...

What I meant to say is that dirty only works with bounded items....

It fires great...I get this error message though in the after_update: Run-time error '7768': In order to change data through this form, the focus must be in a bound field tha can be modified.

Yeah I tried that already, only bound fields can be modified with BeforeUpdate.

Nice, thanks, I didn't know about the "On Current" event I've added some code to just pop up a reminder to add the text (via a cmd button that already exists) but the form goes to the next record any way. Any way to stop it? Here is what I've built so far. Private Sub Form_Current() If Not...

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...

Oh...I had the Not in there on accident, thanks. Just needed a second pair of eyes, thanks.

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=" &...

It worked!! Very big thank you...