Search results

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...

Hey all, I'm trying to amend a piece of code originally from the Access cookbook (great practical examples BTW) that is used as a messaging feature between users of my database. It was written to create a single line in a table tblMessage for each UserMessage. I have amended the code to use a...

Hey all, I have recently begun to admin a split DB that has been in use for many years. The DB has millions of records in about 70 tables. The creator of the DB has no relationships defined and therefore no RI on any fields.:banghead: When I first discovered the blank relationship window I was...

For access to operate properly without risk of corruption you'll need to have each user opening a separate frontend file. That frontend file would normally be kept on users C drive and point at backend tables on O. I've had some success with having each user assigned a frontend file unique to...

you can post your pictures on here. read http://www.access-programmers.co.uk/forums/showthread.php?t=223479 for instructions. Do you have a query built yet for the reports recordsource? In the query that will gather the information for your report you'll need to set the listbox or combobox on...

Do you have a specific question or problem? What is the database not doing that you think it should? What have you done to remedy that block? More specifics needed! Welcome! Access is not easy to learn from scratch but a step at a time you'll get there