Recent content by cpberg1

Spike, thank you for the reminder to define the failure (expectation and result) clearly.

JHB, Thank you for the guidance. Worked like a charm, and I learned something also!

also, will re-name the calculated field "time" to LessonTime. So as to avoid restricted words.

Let me just start with a :banghead: I'm trying to get a query to perform a calculation and round the results. The fields that I am running the calculation and am trying to round are Data Type Number, properties Field size Single and decimal places Auto. I have tried the built in function...

I have a listbox (IncidentStatus) that I want to populate with different choices depending on the users permissions. So far I have the login form working which captures the user level as a global variable (1-4). I want one of the options in the listbox to be "unselectable" for the lowest user...

On the far left under the heading all access objects expand the "tables", (in the jpg "macros" is expanded) ensure you have one called benefitheader.

I suppose this is the key piece of info. With my current setup the bat above would create c:\rasfe\rein.accdb on the remote desktop computer. Same file and location for each user, no? I suppose the proper setup would copy the file into a "my docs" type folder which would be unique to the user...

Also you'll run into issues using this method if you need multiple users on a remote desktop type solution where each user needs a separate copy of the file.

Will you share the name of the third party drag and drop tool? Been looking for one that I know works. Thanks!

Thanks Rain, I have considered using bound forms, and they are used extensively in the database. This form is unbound due to a (perceived?) limitation of bound continuous forms. Namely, the layout of the form needs to be similar to a continuous form but there needs to be running totals between...

The issue is that the new calendar widget automatically displayed next to the textbox when you place the cursor in a textbox with record source with datatype date/time. It covered up (partially) our custom control so when you clicked it sometimes you would get the new style and sometimes the...

You'll see it right away in form view if it affects you. It just happened automatically if the field is too small to display all the data. Worked fine on day 1/1/2013 (only 8 characters) but was obvious on 01/26/2013 (10 characters). Just widen the textbox slightly in design view.

If you use much VBA in the database you'll need to add trusted locations. More info here. Can't get hyperlink to operate properly, posting from my IPad. Copy/pâté to browser sorry. Or google it...

We recently did the upgrade but just to 2007. Not sure how much of my experience will apply to you. We needed to edit trust center settings on each users machine for the path of the FE. Added VBA to setup custom ribbon for MDE/ACCDE users. Also many text boxes that were just big enough to...

Hey all, I'm trying to fix what I believe to be a design flaw in the database I'm working on. I'm creating relationships that didn't exist so I can avoid orphan records. So I find a suitable PK/FK to create a relationship and I attempt to add it with RI enabled. Sorry you have orphan records...