Search results

Shell to a batch file, passing in your arguments, just a thought.

Ok, the underlying problem was that the ProdID was not being entered and is required in the subform. I re-checked the AfterUpdate event and your original statement, using the bang operator does work. In my haste to offer a solution, I changed the bang operator to the dot notation, spent some...

Ok, make sure that you enter all the necessary data into your subform. Your ProdID (the last column) needs to be entered. The error message is because that piece of information is not entered. You also need to address your order of data entry columns, it's all over the place and that...

No, firstly, the two lines are not the same. The first line is what you wrote and I merely commented it out. The second line is what I am suggesting you try. It works as I tested it.

I'm guessing, whereas in this function you purposely created a separate variable that wasn't assigned to the function name, maybe in your other functions where you think you didn't do this is because you were using the function name directly (nothing wrong with that) and so returned values.

As an aside you should get in the habit of giving your controls meaningful names (adopt a naming convention). This is a topic in itself.

Try this: 'Me.Parent!HeaderTotal = Me.Text22 Me.Parent.HeaderTotal = Me.Text22 I tested it, had to work my way around the language barrier, but it worked.

Do any of these events (close, unload, activate, deactivate) fire (well any events really). Upload your db, if you can. Do you have dual monitors as Minty suggested? Dual monitors gives me no end of trouble with forms not opening in the visible monitors (off-screen).

What about in the AfterUpdate event of the ComboBox you assign the value (State Code) to a TextBox. Enter as many as you like. Then with a bit of string manipulation, you will be able to compile an SQL IN operator. Make it fancier still, using the same ComboBox, if entering the same State...

It may have something to do with if you are referencing Screen.ActiveControl in order to perform searches. Just a guess. If I'm not mistaken, a popup form will not be the Active Form, therefore the controls thereon will not be active.

Add this to the last line of your function: TestToAcademicYr = AcademicYr

Or another approach, create a query, at Criteria cell (under your Asset field) enter your form control value, like so, [Forms]![frm_Test]![txtAssetNo] Intellisense will make it easy for you. Use this query as the recordsource for the report. This report can now be called from the form...

I've come in late on this one. From your module 'Update Step 3' this is your snippet of code: If Forms!checklist2!Frame305!.Value = 1 Then sSQL = "Update Issuetbl Set [Issuetbl].[Result] = 'Pass' WHERE [Issuetbl].[Serial_Number] = '" & Forms!checklist2!txtSN & "' AND...

Thanks. I think by now you realise we addressed and fixed your immediate problem but I concur with the others as regards normalisation. The tables really need to be split up. I haven't got a link at the moment though I know one of the regular contributors here has a link in his signature...

At Table design, Open Indexes (from top menu). Enter a name for the index, then next column across, select the field. Next line down, skip the name part, select the next field and so on. Go back to the first field in the index, where the index name appears, you will see information below...

OP, did you get the program to start automatically, as you haven't confirmed this. June7 gave you the 'Autoexec' info. Your initial post #1, I misread it slightly, in that I thought you wrote the update routines in that references were made to 'I did this....." strewn throughout the post...

CJ, you more or less mentioned what I was going to mention. I too was struggling with the logic. Maybe there is logic there but not clearly explained. M..King: Slightly off-topic, I'm curious about the deadline, that you only have one hour to solve it. I know I say this from afar, don't...

Have you tried including the Where clause in the function ConcatRelated and not at the end of the SQL clause. As per the example at Allan Browne's site. SELECT CompanyName, ConcatRelated("OrderDate", "tblOrders", "CompanyID = " & [CompanyID]) FROM tblCompany;

If you can, upload your db, a stripped down version, so that we can see what the issue is.

I don't manipulate images within my apps so can't off-the-cuff advise regarding image manipulation (without myself going to the docs). Something for you to consider though is your table structure. From the image you posted, it appears the sub-table (photos 1 - 4) is in fact a one-to-one...