Search results

WITH USER-LEVEL SECURITY Simply create a field in the table to record the user that created it. Create a text box on your form for that field and set its default value to CurrentUser(). You can set the text box's visible property to false so your users can't even see it. WITHOUT USER-LEVEL...

Something is calling for that value. If it is not in your VB code, check the RecordSources for all controls on the form (and the form itself) you are trying to open. It's in there somewhere. (Remember queries as well - sometimes a reference can hide in a query that we don't remember)

My guess would be that your field contains nothing but is not <b>null</b>. I have never really understood the full difference of the two but solve the issue by using the Nz property. I would change your code to look like this: ="CA" & [lbxCuttingTools].[Column](0) &...

Insert > Rows

Just thinking of all possibilities here... You may want to consider the idea that for one reason or another (a holiday, your office is closed, etc.) that the database will not be opened on the day the call is requested. You may want to make Yes/No field in the table as to whether the call was...

The correct way to structure your data would be to have a separate table linking your procedure codes to each procedure (i.e. surgery). You may want to consider redoing your tables to this structure to avoid problems in the future. If you want to get around it, you could create a static table...

PERFECT! Thank you very much!

I tried to do that and can't seem to get a wizard going. I am trying to export a query to an HTML format. Thanks for any other help you can give me.

SELECT [Field1] AS [NewFieldName1], [Field2] AS [NewFieldName2], NULL AS [NewFieldName3], NULL AS [NewFieldName4] from Table1 UNION SELECT NULL AS [NewFieldName1], NULL AS [NewFieldName2], [Field1] AS [NewFieldName3], NULL AS [NewFieldName4] from Table2 UNION SELECT NULL AS [NewFieldName1]...

I want to export a query to an HTML format. To use DoCmd.TransferText, it asks for a specification name. The help file says: "A string expression that's the name of an import or export specification you've created and saved in the current database." How do you create that?

Why put that on a form? Use a menu bar and you can put the code behind its buttons.

Yep.

You need to create a separate table for addresses and link it to the company names.

Use a wildcard (*) in your code. Your SQL statement should look something like this: "SELECT * FROM tblYourTable WHERE [YourFieldName] LIKE " & [YourTextFieldCriteria] & "*" Entering a 'B' would then get you every record that begins with a B. You can place the * anywhere in the criteria. HTH

The question really is what triggers these fields becoming visible or invisible? In other words, if you want Text2 to be visible when Text1 is not and vice versa, then when is Text1 changed? Put the change for Text2 right there along side it.

I would put the code on the AfterInsert event - after the record is recorded. The code might look something like this: Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("tblDemographics", dbOpenDynaset) rs.FindFirst "[FirstName] = '" & Me.FirstNameControl &...

I'll keep an eye on this post. I solved this dilemna by adding one more option to the option group - i.e. "nothing selected".

Not sure I totally know what you mean, but you can accomplish a drop down by using another form (a pop-up form?) and place your combo box there. Then use [Forms]![myPopUpFormName]![myComboName] as your criteria in the query.

Let me try to troubleshoot this. A few questions: Your table reference (SearchTble) is from a field called Ship_Date. Is that really the name of a table? If I read your code correct, you are trying to establish whether any records meet the criterion and, if so, add them to your table...

That's the right statement. Your references are likely not correct or in the right order.