Search results

Do a linked instead of an embedded graphic. See http://www.access-programmers.co.uk/ubb/Forum1/HTML/007111.html

I'll try one more day...

I haven't solved this yet, and this message will keep the topic on today's list. Thanks.

Jack Cowley: I think you misunderstand the problem, or I don't understand your comment. Once person A has grabbed the top record (call ir Rec01), I don't want person B to even be able to see it; they should get Rec02). I don't see how having the ID as an Autonumber accomplishes this...

I'm trying to set up a queue for a form: The table has a field called AccessStatus that is "0" if the record is available, "1" if it is not. I'm trying to set the AccessStatus to "1" as soon as the form is opened, so that no one else can get it. Here's the code: Private Sub Form_Open(Cancel...

Try this. It's tedious but should work: iif(A >= B AND A >= C AND A >= D, A, iif(B >= A AND B >= C AND B >= D, B, iif(C >= A AND C >= B AND C >= D, C, D)))

Perhaps convert the macros to VB and change the paths there.

LastName = TRIM(LEFT([FullName],SEARCH(",",[FullName],1)-1)) FirstName = TRIM(LEFT(TRIM(RIGHT([FullName],LEN([FullName]) - SEARCH(",",[FullName],1))), SEARCH (",",TRIM(RIGHT([FullName],LEN([FullName]) - SEARCH (",",[FullName],1))),1)-1)) MiddleInitial...

why not try if me.quantity > 0 then me.quantity = -me.quantity end if

for LENGTH use len() for SUBSTR use mid() for RTRIM use trim()

Oops, my bad. Replace TEXT with STRING and try that.

I'm not sure I understand the question. On your report, replace the control that formerly help the name with the new field from the query.

I think you mentioned that you are generating this report from a query. Why not do it in the query?

Found it! Change to: strTgt = "ClaimFormNumber = '" & [Forms]![form1]![CFNumber] & "'"

Try this: iif(len(trim(x)) < 22, trim(x) & text(22 - len(trim(x)), " "), x) where x is your merged name.

Here's the problem: I'm trying to enter a value on form1 and have form2 open to that record, but be able to navigate to records before & after the target record. Here's the code I'm using: ******************************** Private Sub Form_Open(Cancel As Integer) Dim strTgt As String...

The command line should be excel.exe "complete path to file.xls" Make sure you have the path in quotes.

Use the RunApp command and supply the necessary command line.

Go to the Design view for the table and add a field.

Here's my code: Private Sub test_Click() On Error GoTo Err_test_Click Dim dbs As Database, rst As Recordset, intRecordCount As Integer Set dbs = CurrentDb Set rst = dbs.OpenRecordset("qryQCMainSizeCheck", dbOpenDynaset) I get the following error message: "Too few parameters. Expected 1."...