Search results

Can someone look through this code and give a hand? I'm running into an issue where if the user clicks No on the msgbox at the end of the code, nothing is updated in the record. If they click yes, then it will update the record. The message box's purpose is to allow the user to rerun the form or...

Thanks for this Linq, I've decided to format my form a different way that makes more sense to the end users after getting their opinions, but I'll keep in mind that for later comboboxes where I see that might be helpful! Also I'm aware of the reserved name issue, was just giving an example...

I have my display set to properly show the columns I want when the combobox has dropped down. Let me try phrasing my question differently: If my query returns the following table: ID Part Number Name Batch 1 123 Blue Box 032118 2...

I have a bound combo box that the dropdown portion displays 2 columns. The bound column is 1, and the columns of the query I am displaying are 3 and 4. Is there a way to make it so that when a line is selected, only the value from column 4 shows up in the combo box? I have a dependent...

What kind of dogs do you have? (I wish I could keep mine at work with me :P )

Welcome! I'm a new user after a 2 day course too, so I know your struggle. Rest assured the group on here is by far one of the best I have found in the past few months of working with Access!!

Okay, I'll look into this. Thanks Pat! Also I'm going to mark this as closed, since I feel my questions have been answered. Thanks to everyone for their help!

After letting my brain relax this weekend I have a better grasp I think of what you mean by not getting in the way of Access. So I did some digging around and found what seems to be a more involved data validation code which I have dropped into a module and am calling in the BeforeUpdate part...

Ok that makes sense. Could I set it up even more generic so that where you changed it to frm.DateIn = Date frm.TimeIn = Time I could replace the DateIn with something like strDate then in the part on the form have a statement Dim strDate as String strDate = DateIn and just change it from...

Pat thanks for your answer here, I'm dropping the code I have written for the login button I have set up. This is almost identical code for several other places but the Me.DateIn and Time in bits get changed to "Picked" and "Out" fields and the MsgBox at the end gets some different wording...

Yarp, they are bound forms. Thanks for the direction!

They are Private subs on each form. Thanks! I'm pretty sure my forms are bound, they pull a record source from a specific table if you are editing, or add to that table if it's a new entry. as far as I have seen, the way I have it structured it isn't changing any data in the tables unless I...

I'm new to Access/VBA and I want to get opinions from y'all who have more experience on whether or not this is a bad practice while I'm early on in my database design/skill development. My database has a bunch of forms which allow FE users to enter and selectively edit information. I am...

Lol well if it's not super easy it's not important enough to find the workaround, just aesthetics. Thanks for your help Minty! Thread Closed!

Setting the tab stop worked great. Is there a simple way to change the color of the highlighting? I found a thread on here about forcing focus and highlighting using VBA, but if there's a simple button I can click that would be wonderful

Okay, I'm not even sure if this is possible, but I'll ask anyway. Purely an aesthetic thing, but I'd like to make my form stop highlighting a field when it loads. This form loads after a user double clicks on a particular record in a continuous form so they can edit the QC Disposition block...

Thanks Minty, I plan on doing that once I get to my next stuck point :D

Hey nevermind my last posting about the Me. not doing something, I figured it out! The form that Me. was referencing didn't have the DateIn/TimeIn fields physically on it, so the lines Me.DateIn=Date() and Me.TimeIn = Time() didn't know what to reference. I've added those fields onto the form...

Okay, that makes some sense. Since we are more concerned with the past two business days, I should use the Date version rather than the now. Also, thanks for the info on the codecontextobject. I grabbed that from a piece of code I found somewhere else and it worked. But I've rewritten the...