Recent content by applevacross

Hi all, I am currently using a frame with two radio buttons controlling two combos to switch between search requests. I can enter by name or switch to serial and enter likewise. The output is generated in a sub-form of all records by that name or serial. Mostly name, since of course serial is...

Windows XP Pro/Office 2000 I was able to output to excel before fine, now all of a sudden I cannot. I keep getting a message when I go Tools>Office Links>Analyze with MS Excel: "Cannot access "xxxvac_Inv_DBQuery.xls" It's wierd. It won't output the data, but it still creates the spreadsheet...

Excellent, Perfect. Thanks much. I'm learning from those who know!

Thanks for your reply! Well, something real wierd is happening. Cancel works perfectly, however, when I click Ok, the mainform closes, not the existing dataentry form. I click the button again>Select ok again, then the dataentry form does close. Am I somehow bound to both? Thank you for your reply!

Hi all, I've added a message box to what is basically a standard simple to use access control, "closeForm", I'm a newbie working on learning access vb. I'm guessing my code if fudged. Any help is greatly appreciated. Private Sub Close_Click() On Error GoTo Err_Close_Click Dim Answer As Integer...

Or here is an even better way, I just learned this the other day but the database has to have security, meaning the users must have to login first. Create two new fields in your table ex. UpdateBy and LastUpdateDate Next, On the form your users are accessing; create two new text boxes with the...

In the forms OnLoad event enter the following code: The form will open blank all the time. Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

Hey, Thank you so much; your kindness and expertise is greatly appreciated!

:confused: I would like to create a popup on my combo box to do the following: When a serial number is entered and no records are found, it prompts "no matching record/s available" and no controls show data. Currently, if I enter a serial and no data is found, the control options stay with the...

In the properties of the form, make the form border none. It'll come up centered by default. Hope this helps!

Good morning all, I have a quick question regarding my data entry form in my Database. I created the form so that Users would be able to submit software requests via the db. However, it seems I'm the only one who is able to use it. Obviously being admin I should be, however, I've adjusted their...

:confused: I've created a form within our company database which will track hardware/software requests. I'd like to create a macro, or add code to output the data entered into a notepad file. Nothing extraordinary. I'd like for it to be like this: Ticket: XXXXX Employee: xxxxx Reason for...

Does anybody know how I can change the default mail client from Outlook to Lotus notes? I'd like to use the sendObject utility to create a macro which sends data I enter into my form. Thank you to all ahead of time :rolleyes:

:confused: I have created a frame which controls two seperate combo boxes for searching based on either serial or name. What I'd like to do is have the user combo box [after update] to open a sub form with all of that specific users particular assetts. Only by that user. HEre is the code for...

Well done. We're in business. Thank you Bob!