Recent content by Briandr

query help Hi All, I gave this a couple days before deciding to come back here and address it again. Is anyone willing to look at this if I sent it via e-mail?? I made a mistake before in another forum by posting a db. I really don't want to post even a stripped down version. The only way I...

Can I e-mail it to you? Send me a private message with your e-mail address if your Ok with me e-mailing you. I am not a spammer and don't harvest e-mail addressess. :) One thing I should mention if I e-mail it to you is that since one table is linked you won't be able to do much with it. You...

WHERE EmployeeMaster.EmployeeID=[Forms]![frmMenuSwitchboard]![ComboBySelectedEmployee])) It did not like the two ')'. I removed them and it still prompting me to 'Enter a Paremeter Value' when I select a name from the pull down list. Here is the code that populates that pull down list. SELECT...

Could you help me with the code. I am not that good of a coder and the stuff I posted originally someone helped me with that. The two id fields that have the PK set to them are Acc & EmployeeId. Many Thanks.

Do you want me to Change this : WHERE ((([Lastname] & ", " & [Firstname])=[Forms]![YourFormName]![YourComboBoxName])) To this : WHERE ((([FullName])=[Forms]![frmMenuSwitchboard]![ComboBySelectedEmployee])) Now its prompting me to put a full name in and to enter a parementer value.

I'd like to re-visit an old problem. If the problem required viewing the database I can strip out the data and e-mail it. I don't want to post it though on the forums. On the combo box on the form Row Source Type = table/query: Row Source = SELECT EmployeeMaster.EmployeeID, Lastname & ", " &...

Hi Bob, What I would like is the text box to be visible at all times. This line of code causes the text box to flash: Me.YourTextBoxName.Visible = Not Me.YourTextBoxName.Visible The other thing is I want the status bar text to flash, not the text box itself to flash. I think I understand...

Hi All, I am looking for a small code example as I wouldn't be able to code it. I'd like to use the control 'On Got Focus' and have the text flash only while the text box has the focus. After the focus is lost then I wouldn't need it. I now flashing text can be considered annoying, but I was...

Can IDENT_CURRENT be used in Access 97 or above as shown in the example below? Set delayTable = db.OpenRecordset("SELECT * FROM tblDelay WHERE DelayId = IDENT_CURRENT('tblDelay')", dbOpenDynaset, dbSeeChanges) When I go to Debug->Compile Loaded Modules I get no errors. When the code runs then...

Ok. I already had a query that sorted them out for the form that lists them. How do I set this up so we have them print in order: B1 B2 B3 as oppsed to: B1 B11 B12 B2 This is what I did in the query: SELECT JSA.ID, JSA.JSANo, JSA.JSATitle, JSA.OriginalDate, JSA.RevisionDate...

Thanks! That worked great. Only one thing I'd like to tweak. Can I get them to print in order. In order would be: B1 B50 B60 etc etc. Right now its printing them randomly and not in order. Again. Thank you!

I stand corrected. The field type is text and not number.

JSANo is a number. The command was working fine until I added on the last part: and "[Area] Like 'Knife'" Thanks!

DoCmd.OpenReport "JSA", , , "[JSANo] Like 'B*'", and "[Area] Like 'Knife'" I get a Runtime error 13, data type mistmatch. I have played around with this for a while and here is what drives me crazy. It will test clean in the compiler and then throw the error at you when its run. Is Access...

Hi Guys, I wanted to get back to this alot sooner, but other things pushed this aside. I looked at Bob's example. Please tell me if I am putting more into this than I need to. For starters I think a query would work best because new data would be added in continuously. So let's go that route. I...