Search results

It adds " " around your file name making it read: Call Shell("blah\blah blah2\blah\blah.bat" rather than: Call Shell (blah\blah blah2\blah\blah.bat) The first will work, the 2nd won't because of the space. chr(##) = ASCII code call. 34 being a "

Your set is strangely declared. Set rstChild = rstCurrent.Fields(strFieldName).Value ' per comment, this returns a recordset? I'm not so sure... strFilePath = strTempDir & rstChild.Fields("FileName").Value Try commenting out rstChild and use strFilePath = strTempDir &...

TLDR; I looked at your db and can't relate it to what you're asking. Your table relationships are a bit off: - tblScores should be linked to refAdvocate via AdvocateID. - refAdvocate AdvocateRoleName should be RoleID - and linked appropriately to the PrimaryKey (PK) from table refRole I...

Good thinking. You'll learn a lot faster if you attempt this first. Also, every basic math course and intro programming course will be using arrays; given your handle, I strongly encourage you to read up on basic array functionality, declaration, and usage (which will be fairly universal...

This is a good thing. It's proper for normalization. Once you are sure you're query lists all appropriate data, normalized - it's very easy to go to the query - change the view to "Pivot Table" then just Drop the PaperID in the columns section. FYI: If you have 50 papers to a single species...

That did it - thanks! I won't ask...but I'm extremely curious what's going on behind the scenes... :T

Your code is updating all the Form objects, NOT the table data. Unless you've specifically linked your form to the table already, updating the form through me.ObjectName VBA will only change the visuals on the form - NOT update your data table.

User CP > Edit Options (left hand menu bar) > Messaging & Notification > Default Thread Subscription Mode > "Instant Email Notification" You probably also need to Accept Emails from Admin and confirm e-mail is correctly listed. If all these check out -- Notify server admin. :confused:

^ You can delete your post, instead of just editing it :D Form Events: KeyPreview = YES OnKeyDown = ... Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyDown Then DoCmd.GoToRecord acDataForm, Me.Form.Name, acNext End If End Sub You'll...

Check the table.field that combobox.columns(4) is based on. I'm guessing it's a text field containing some values which are numbers and some values which are strings (have letters). This would explain your error 13. It will work for some of the time, until it hits a string, which would ->...

hmm. Anyone else having trouble opening the db? :confused: Tried refresh, repaint, requery, echo true/false during the process...nothing works so far.

I have 2 (btnX, btnY) command buttons in a form header. I have 1 (btnA) command button in a form detail. When I click btnA, it unhides a record selector and moves the buttons... Now when I click btnX and btnY, I can't click directly on the button - but need to click a quarter inch to the...

If the initial 3 queries work, why change it? Also - could you provide all 3 working queries? And your two recordsets aren't joined - is this a problem?

1 query + 1 dynamic filter = 90 different outputs. Make a form. Add a combobox to it. Populate the combobox with all customer numbers. Add the following criteria to your Query under CustomerNumbers field. Forms!YourFormName!ComboBox1

If you've disabled shift bypass, I assume you're running with automated startup forms. On EVERY form, do the following: KeyPreview = Yes Event: OnKeyDown Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) isAltDown = (Shift And acAltMask) > 0 If isAltDown Then...

Turns out it's significantly easier to move every object on the form out of the way than attempt to layer above those listboxes... :( Subform falls under.

Set Rs = CurrentDb.OpenRecordset("NameOfYourQuery") i = 1 While (Not Rs.EOF) AND (i + 1 <= TotalNumberOfTextBoxesOnForm) Forms("YourForm").Controls("TextBox" & i) = Rs("FieldName1") Forms("YourForm").Controls("TextBox" & i+1)= Rs("FieldName2") i = i + 2 Rs.MoveNext Loop Will fill in...

This sounds like normal behavior to me? Anyone who opens the FE form can VIEW the same record. It SHOULD appear on the form of the other user. Could you clarify the following: These two statements seem incompatible... Another user cannot use the same form - Every FE has its own unique set...

Tried. Listbox magically appears on top of every other object I throw out there, no matter how many times I click 'Arrange > Bring To Front'

:o I stand corrected. I was holding out hope for a one-liner-built-in feature so I could avoid the hassle of reviewing a new function or blackboxing a process. Thank you for the help and the links.