Search results

Hello, I have a form which is consistently slow to load. Is there some way to make Access 2003 tell me what it is doing behind the scenes while the hourglass mouse pointer is displayed? Background: Unbound form with text boxes for entering search terms and list boxes for displaying results...

At risk of looking ignorant, I think if the records are rejected then they won't have been written to the database, so you won't be able to retrieve them?

Sorry I can't think of a solution - but if you have time to reply, I'm intrigued to know if by 'shop' you mean a retail shop, or something like a workshop?

Sorry - just realised how dense I was, not reading your original post thoroughly!

Also, do I need to run the security wizard on the backend and front end separately?

Hmm - I have myself in the Admins group under my own name but when I try to delete the user 'Admin' it says that operation cannot be performed. It will let me remove user 'Admin' from the Admins group (leaving Admin in only the Users group which has no permissions). Do you know if that would work?

I've been trying to grasp User Level Security on here and around the web but one thing is leaving me lost. I have a backend on a fileserver, with a .mdw in the same folder. On a user's machine I have a front end and a shortcut which specifies to use the .mdw on the fileserver. If the user...

I normally get an error if *any* part of a text box fails - any chance that it's as simple as not enough room in the box to display the date?

I use a ListBox with multi-select for this purpose, in a modal form that pops up from the main form. A button on the pop up runs code which iterates through the items selected in the listbox and inserts them into a table. The last items in the VBA are refresh the main form (which will then...

If you make a section header in the report based on the staff name you can avoid repetitions of the name. You can summarise by month etc. as well, but I can't recall how to do that.

Assuming you are using Access, your simplest option is to use it's form design tools which produce forms that run inside Access. You can get the job done without using any external tools.

Need to define 'Region' as well. In the UK it is often taken as meaning a subsection of one of the countries (North Wales, Western Scotland, South West England), but you could equally mean 'Middle East' or 'South America'.

You might only need ProductsTable ProductID. Product Description. ProductionTable HeadID, ProductID, Date, TotalProductionThisDate A P1 9-12-10 100 B P1 9-12-10 100

It sounds like you want the layout of the report to change for each record, based on the null/not-null status of certain fields. Sorry, I don't know a good way to do this, but the quick-n-dirty way is to have a text box with it's Control Source property set to =[field1] & " " & [field2] & " " &...

As a safety feature, Access (some versions) can be prohibited from affecting parts of Windows external to itself . http://office.microsoft.com/en-us/access-help/hide-the-unsafe-expressions-security-warning-message-in-access-2003-HA001107133.aspx

That looks good - will try it later. Thanks.

Hello. I have the following code which is intended to check the spelling in a Comments field. I can't understand why it also checks the Name field on the same form. I want to restrict it to the comments field because the Name field is locked in the form in question (and people's names often...

Pretty harsh that your final project is a full sales database with customer analysis, yet it seems they haven't prepared you with simpler projects (as you said you are a newbie). I would raise a complaint with the institution you are studying at.

Race/ethnicity categorisation is (I find) a big headache before you even get to setting up a database. You could have a people table, a race/ethnicity table and a junction table between them which would allow a person to define themselves by any mixture they require. This means when Bob wants to...

An in-vehicle terminal is standard for the govt. emergency services in general here, but the OP is programming for an independent company. Likely they are providing cover at special events and their activity level will only require a radio operator entering data onto this form at a control...