Search results for query: *

Thanx Elizabeth...I'll give it a try ;)

Hi All,<br> <br> I'm trying to allow the user to choose the name of a dBase file being sent for importing or linking into my database, but can't seem to get past the required argument TransferDatabase/Filename. I checked the help files for a while, and they weren't very helpful in showing...

Got a doozie for yall.<br> <br> I've have a novell network-based Access 97 SR-2 invoice database running nicely for the past couple years...holding around the 400 meg mark. It's been running on 486's, Pentiums, and PII's without a hitch.<br> <br> The problem started when we installed two new...

Hiya,<br> <br> Might have another 2 cents to add. Try changing the locking in the source object to snapshot and see if that changes your situation. It might be that the record that you're opening when starting the database is already being accessed by the first user, and cannot be seen.. It...

I've done that with a few applications by just putting the mdb file on a shared network drive. From there I've created shortcuts from the individual's desktops and most have been running fine for the last 2 years.<br> <br> Instructions for this recommend using the database splitter in the...

Here's one that frustrates me to no end! <br> <br> I know about MS Snapshot export format as useful in creating email-attachable report copies for convenient distribution...well, almost convenient. They have to have the software, too.<br> <br> Export to MS Word messes up my report formats, is...

Hiya Geekette,<br> <br> This is as far as I got on your question. Used as a control source for a control, it results in a date formatted control.<br> <br> Month(Now()) & &quot;/&quot; & [Form control Name] & &quot;/&quot; & Year(Now())<br> <br> Hope this helps!<br> Drew

WOOHOO!! <br> <br> After a couple more hours, I finally made that dang bird fly...Thanx for pointing me in the right direction, Al.<br> <br> Happy holidays,<br> Drew

Thank you for your response.<br> <br> Is there a way for the 'INSERT INTO Table1... ' portion of the example to be similar to 'INSERT INTO [Forms]![frmInputForm]![txtInputField1] (interpreted by SQL as a table])'<br> <br> Perhaps I could dim a table variable and assign the form control to that...

ty for your reply, Rochelle.<br> <br> I tried for a couple hours today, but kept getting a user-defined type error on the &quot;...as text&quot; statements. Tried changing it to type string, but then i got an error on the 'set rst = dbs.OpenRecordset(strSQL, dbOpenDynaset)' line about different...

This one has been bugging me for some time.<br> <br> I'd like to determine which table to insert a record into after validation of the entered values, and based upon one of the user's selections on the form. It seems like a reasonable action, but I'm still a novice at sql, so have chewed my...

Thanx Rochelle, I tried that criteria trick, and now can seriously cut down the number of queries in my application. <br>

This has been a problem I've wound up duct taping a number of queries together to solve...but I think I found an easier way. The Nz() function has a description of &quot;Nz(variant[, valueifnull])&quot;, so is it possible a wildcard could be inserted as the value if null in the query?

Run an append query of that information to the destination table is the way i would do it, setting warnings off.

Hi All,<br> <br> New to this forum, but this is a problem that's been stumping me for some time, and wanted to see if I've been looking too hard at the wrong solution.<br> <br> Rather than a lengthy sub-report listing matches to it's parent, I'd like a single control on a report (or sub-report)...