Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 140
Search took 0.01 seconds.
Search: Posts Made By: helmerr
Forum: Modules & VBA 02-03-2019, 05:00 AM
Replies: 8
Views: 289
Posted By helmerr
Re: Answer 'No' to Save produces error

This particular form will rarely be used; it was a replacement for one built with MS works. I'm not sure how to insert rows dynamically so I kept it as is. However if you can be so kind as to point...
Forum: Modules & VBA 02-02-2019, 02:43 PM
Replies: 8
Views: 289
Posted By helmerr
Forum: Modules & VBA 02-02-2019, 12:58 PM
Replies: 8
Views: 289
Posted By helmerr
Re: Answer 'No' to Save produces error

Hanks doe your response. Does that mean it would just bypass that portion of the code if the user answers no? Everything appears to work ok otherwise.

Iíve never just wrote error handling. Could...
Forum: Modules & VBA 02-02-2019, 11:13 AM
Replies: 8
Views: 289
Posted By helmerr
Answer 'No' to Save produces error

The code from the link below prompts a user to save the current record before changing records if the form is dirty. I've put this code in my form, but it produces an error anytime I select No to not...
Forum: Modules & VBA 02-02-2019, 07:17 AM
Replies: 5
Views: 219
Posted By helmerr
Re: Open record from combobox

Lol - thanks, that fixed it. I originally took the unbound route because the last database I had to make was quite big and complicated.
Forum: Modules & VBA 02-02-2019, 06:32 AM
Replies: 5
Views: 219
Posted By helmerr
Re: Open record from combobox

Thanks for your help. I tried both your codes but I'm unfortunately receiving the same results. It's a fairly simple database; I'm uploading it here if you have a chance to review the combobox/form.
Forum: Modules & VBA 02-02-2019, 06:14 AM
Replies: 5
Views: 219
Posted By helmerr
Open record from combobox

I have a form "frmRequisitions" with unbound controls which is used for data entry.

I've placed a combobox in the form header which I would like to use to filter previously saved records from the...
Forum: Forms 02-25-2018, 12:27 PM
Replies: 12
Views: 924
Posted By helmerr
Re: Form controls not updating unless click outside control

Hmm.. I never thought of that. Let met think about this again..
Forum: Forms 02-25-2018, 07:25 AM
Replies: 12
Views: 924
Posted By helmerr
Re: Form controls not updating unless click outside control

I think I've got it:
I had needed to put the above command "me.txtVehicleID.SetFocus" as the first event in the cmdSave button.

Thanks for your help.
Forum: Forms 02-25-2018, 07:10 AM
Replies: 12
Views: 924
Posted By helmerr
Re: Form controls not updating unless click outside control

Hey guys - I've attached a copy of the database.

Also, I set tried using me.txtVehicleID.SetFocus on the control txtOdometer's After Update event (since this is likely the last control to be...
Forum: Forms 02-24-2018, 06:46 PM
Replies: 12
Views: 924
Posted By helmerr
Re: Form controls not updating unless click outside control

Hi Mark,

My form is actually composed of one main form and two subforms. The top subform allows for new entries and edits, and has command buttons for adding a new record, resetting the form as an...
Forum: Forms 02-24-2018, 06:11 PM
Replies: 12
Views: 924
Posted By helmerr
Form controls not updating unless click outside control

I figure there may be an easy solution for this one:

I'm trying to add new records using a form with text and combo boxes. On the form's On_Load event, I using the command DoCmd.GoToRecord , ,...
Forum: Forms 02-19-2018, 04:05 PM
Replies: 4
Views: 802
Posted By helmerr
Re: Error handling docmd.runcommand

Thank you all for your comments and suggestions. I don't know why I couldn't figure this out yesterday..
Forum: Forms 02-19-2018, 03:41 AM
Replies: 4
Views: 802
Posted By helmerr
Error handling docmd.runcommand

I'm attaching a sample of a database I've been having some minor issues with. While the form and buttons work, I'd like to work out one final bug:

The sample DB consists of three forms: one main...
Forum: Queries 02-10-2018, 01:58 PM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

never mind; I guess I missed copying part of your code. It works now. Thanks so much!
Forum: Queries 02-10-2018, 01:26 PM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

Thanks for both of your ongoing support here..

Syntax error in string in query expression '[Odate] Between #02/10/2018# And #02/10/2018# And [VehicleNum] Like '*".
Forum: Queries 02-10-2018, 01:08 PM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

I get a syntax error on this one :-(
Forum: Queries 02-10-2018, 08:59 AM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

That works! May I ask, is there a better way to run this code if a VehicleNum is not selected from the combobox, without an IF statement? So, if a VehicleNum is not selected from the combobox, the...
Forum: Queries 02-10-2018, 08:46 AM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

Hm.. Data Type mis-match. I should note, VehicleNum is short text.
Forum: Queries 02-10-2018, 08:30 AM
Replies: 13
Views: 1,354
Posted By helmerr
Re: Build report with form controls and VBA

Hi boerbende, I receive a compile error on all the suggested options that highlights "acViewPreview" that says Expected: named parameter.

I also forgot to include my combobox in my code. Please...
Forum: Queries 02-09-2018, 06:56 PM
Replies: 13
Views: 1,354
Posted By helmerr
Build report with form controls and VBA

Hey guys -

In my existing, I take a beginning and end date obtained from two text box controls, then use this information to build a report. The code is seen below.

I'm trying to incorporate...
Forum: Modules & VBA 01-22-2018, 05:03 AM
Replies: 3
Views: 259
Posted By helmerr
Re: If Then evaluates incorrectly.

Ah, yes. Thank you. That makes sense.
Forum: Modules & VBA 01-22-2018, 03:47 AM
Replies: 3
Views: 259
Posted By helmerr
If Then evaluates incorrectly.

Hey guys - Can anyone help me figure out whats wrong with the IF statement below? For some reason, the else statement is evaluating whether or not If ext1 = jpg Or png Or bmp Or jpeg Or tiff Then is...
Forum: Forms 01-14-2018, 01:39 PM
Replies: 9
Views: 1,213
Posted By helmerr
Re: Attach Files to Access Form (Shared Path)

Hey guys - I think I've about got this complete.

I'm now able to copy files from the source to destination on a file share B:\Attachments. Files are renamed successfully and include the file...
Forum: Forms 01-09-2018, 08:09 PM
Replies: 9
Views: 1,213
Posted By helmerr
Re: Attach Files to Access Form (Shared Path)

Thanks for the attachments. I actually couldn't figure out how to apply them to my database, but I did find a youtube video that did mostly what I was trying to accomplish at...
Showing results 1 to 25 of 140

 
Forum Jump



All times are GMT -8. The time now is 03:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World