Search results

Hi all, I created a form and initially though I would want it to be a pop up form, so I set the Pop Up property to yes. After testing it for a bit I decided it would be better as a tabbed form so I set the pop up property to No, but the form still pop's up when I open it. I've closed the db...

Just out of curiosity, what are you trying to achieve with this warning? Are you trying to determine maintenance when the AC hits its TBO time, when it's time for the 100 hour inspection, or something else?

Okay...I've been trying to figure out how to do this, but can't get it. The client wants a form with several buttons across the top of the primary form. When they click on any of those buttons they want the associated sub form to appear down below the buttons on the top. ie. buttons across the...

Hi all, I'm trying to create a button that when click will open a form and go to the hoursentry_page tab, but I can't seem to get the code working. Does anyone have any idea how this could be done and could you provide an example? Thanks in advance.

This is awesome. I've been looking for a way to do this, but with the visible property instead.

Updating the FE will be extremely rare, but I get what your saying. Thanks for all the help gents.

No plans to store logins. Just need to pass the ID and use it to open one or the other form.

You are correct, JBB. My question now is once I retrieve the user's login ID, do I use a Case statement to determine which form they are routed to or an If/Then/Else.

Hi all, I'm assuming it's possible, but haven't a clue as to how to go about it, to have a user directed to a specific form based upon their windows user ID when they launch the DB. Anyone know how to accomplish this? Thanks in advance.

Client doesn't want tabs for whatever reason. Go figure...

Is it possible to use a command button to change between subforms on a form? Example, the primary form has subform1 displayed in the lower part of the form. User clicks a command button and subform1 gets switched out with subform2

An accde file is not an option at this time. I'm looking specifically for a way to utilize the disable design view shortcut option as it is probably the quickest way to achieve what I need. Thanks for the link, but can't use it t this time.

Hi all, I want to keep users from accidentally stumbling across the design view option when they right click on a form. I need to keep the "allow default shortcuts" option checked in the database options so they have right click functionality to sort, hide/unhide fields in datasheet views...

Hi all, I've got a report that allows the end user to click on an email button. The button launches a macro using sendobject, pdf's the report, and attaches the pdf file to an email. The problem is until the user actually sends the email they cannot switch back and forth between outlook and...

Hi all, I've got some tables that certain individuals will have access to so they can update the data. The DB back end is SQL server using windows authentication, and I was wondering if anyone knows if it is possible to grab the users network name and then drop that info into a field when they...

Grrrrrrr.....Since you said that should work I tried it again...this time I used the expression builder and it worked just fine. I must have fat fingers. Guess I'll use the expression builder to be safe from now on. Thanks once again, Paul.

I've got a form that requests a start and end date to be inputted by the user. Once the user click the okay button the form passes the values to the report which queries the data and generates the report just fine. What I can figure out how to do is take those same start/end date values and...

Ah...Thank you once again, pbaldy.

Hi all, I've got a form that contains two fields for date inputs and then will run a report based upon the dates provided. The code checks to see if the date fields are left blank, and if so, is supposed to pop up a message. Problem is I get a compile error on the line in red. Any ideas...

ChaChing...I forgot it had do be viewed in Print Preview. Works great. Thanks guys!