Search results

Just this one. It works in other databases.

I'm still not able to step through my code. Anyone have suggestions? Is there a setting somewhere that got turned off?

Ok, arnelgp.

Yes, I do have have the password.

Nada. No response with ctrl+break

I get the "Beep" noise from my computer and nothing happens.

I'm working with a password protected DB and can't debug the code using the ctrl+F8 feature. There's probably a simple fix this so does anyone have any suggestions?

https://www.youtube.com/watch?v=OXrwumT3JUo Simple.

I'm guessing this type of security is not possible?

The FE only allows users to 'get' data via reports. I don't want users to be able to easily copy the BE data and save into excel.

All, Is there a way to disable the ability to Import and Link the BE of a database? I've added several security measures to the FE and BE but all the information in the BE is still easily accessible if the user makes a new database then links or exports the tables. Can VBA disable some of the...

Just kidding guys, this does not work if you split the database. Help?

Solved my own problem, merge the back end to the front end. Then split after the lookup record has been added.

Hello all, I know this thread is pretty old but I am having difficulty working this exact same problem. My tables are split into a back end and I can't reference the query in the lookup action. My first thought was to create an update query that could pull the tempvar then push it to a table...

Ok, I guess will revisit the idea of storing that value.

DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tResults (ProductName, TestName, LotNumber, TestingDate, Technician, TestResult, PassFail) " _ & "SELECT '" & Forms!fMain.Product & "', tTempTblResult.TestName, """ & Forms!fMain.LotNo & """,#" & Forms!fMain.TestingDate & "#, '" &...

I'm using this field in a Temporary Table so it's almost like a query lol. I have a calculated field in my temporary table then some code which puts the values into a permanent table. So my calculated field just calculates whether something passes or fails then stores "Pass" or "Fail" in a...

Try creating a calculated field in a new table real quick. IsNumeric cannot be used in a calculated column!

IsNumeric is not a valid expression I can use in a calculated field

Hello All, I have a calculated field which is based off a text field which can contain text values and numeric values. I'd like to add a statement in the criteria which performs some action if the value is text. IsNumeric is not a function I can use in expression builder so I'm thinking of some...