Search results

Anybody see why I get an "Invaild use of null" error when I open a form that has this code behind it? All it is, is a form with an unbound text box and this code. Thanks, Matthew Option Compare Database Private Sub ScannedBarcode_enter() On Error GoTo Err_ScannedBarcode_Click Dim...

Thank you, Thank you, Thank you!!! That's exactly what I needed. Works perfectly...

Need help getting this.. Need to check the value of a barcode in a text box to see what the first character is. Like this; If the first character in txtScannedBarcode is "M" then I want it to open frmM If it is a "B" then I want it to open frmB and so on. The values would be along the likes...

Thanks for the help, I am going to start in heavy on this, this week. I'll probably have more questions. Thanks again... Matthew

Ok, I hope I can explain this so everyone can understand what I need. I know all the relationship stuff, linking and tying the records together. I need a way to keep track of parts that go into machines, these parts can be changed frequently and interchanged from machine to machine, and I need...

Can you post a screen shot?

I hope you can understand this: I am looking at making a form to show around 10 small charts. I would like to somehow have a query or something that would get all the unique sample names in a table and make that many charts (each sample name having its own chart). So lets say when someone opens...

Use the "on enter" event

First off thanks for this audit trail ghudson. Next, I admit, that my knowledge of VBA is limited. I worked for a while last night trying to get this bit of code to write to a seperate table instead of the one that it is. Is that possible? If it is can someone point me in the right direction...

Are you using a query for the data or straight from the table? If you are using a query set the max date that way.

Cover it with a rectangle that matches your background.

Thanks everyone. I was able to find some info finally. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrunderstandingchartcontrol.asp Now the problem is getting it to work, I keep getting errors with everything I try.

I have searched high and low and only able to come up with answers pertaining to excel. I would like to know if there is a way to control different properties of a chart from VBA such as the scale of the axis. Thanks, Matthew

No problem. I save my bosses career everyday. :D I also misspoke. I didn't make the form unbound I made the controls unbound.

A just in case comment, you also need a qoutation mark at teh end of that statement after the ;

Ooops, sorry forgot about the new record. Here, I made the form unbound and using VBA to store the records. There is probably a better way to do it, my knowledge is still pale in comparison to everyone else here, if there is someone will come along and fill you in.

I took a look at your sample, and by your post and the form it looks like you just want the user to enter their responses and then the form closes, correct? The easy way around that is in hte form properties and the data tab change the "data entry" to yes. That will prevent them from seeing the...

No problem, I have done it many times. You search for things here or in the help file and don't have the wording right, and don't come up with anything you want.

In the access help: Example The following example uses the GetCurrentView subroutine to determine whether a form is in Form or Datasheet view. If it's in Form view, a message to the user is displayed in a text box on the form; if it's in Datasheet view, the same message is displayed in a...

I am trying to use DLookup to get a value from a previous record on a form. The value I need is in an unbound textbox that performs a calculation. I have discovered that the DLookup doesn't work correctly with an unbound control. That wouldn't be a problem as I could just do the calculation in...