Search results

I have a calculated text box on a continuous form that doesn't paint in form view unless I click on the box. Any ideas why this might be?

MS Access is a Database management system (DBSM). SQL is a language used to interact with databases. MS access provides you a GUI to manipulate the SQL. ...more or less.

See attachment dummy example

Make your query so you have your standard normalized query. Convert Query to a pivot-view. Move your [TestName] field to the Columns section of the pivot-view.

All three tables require independent data input. Think of it as 2 separate lists - A list of all your Contractors (textbox to add new contractor) - A list of all your Locations (textbox to add new location) And 1 final list that links the two - a list indicating which locations go with which...

No. Joining two tables is the point of Queries Also, unless it's a foreign key, you would almost never want to do this (see - wiki "Normalization")

Do you get a warning message saying you can't run the code because it's "Suspicious" ? What error number is that? And is it the same error number as an "execution error" ? It sounds to me like you may have compatibility issues beyond your Trust Center trouble.

This could be a number of problems. Version incompatibility - does everyone use the same version of Access? - same version of Windows? - etc. - Intranet / network trouble - if the network hiccups on your end-user, the access front end will drop connection to backend; frontend will still...

Dim xlApp as Excel.Application ' early binding Dim xlApp as Object set xlApp = CreateObject("Excel.Application") ' late binding

If there's 600 combinations, there's 600 combinations. Whether it's in one column (field), or split between 5 different tables and 5 different columns, you still have the same data. Having just 1 column for all the data keeps it more organized and easier to retrieve/manipulate -- much much...

Access can be a bit finicky. Consider dropping the whole thing into a continuous form to manipulate appearances. Good luck!

Are you right-clicking specifically on the header? It should highlight all fields associated.

Are you subtotaling any of the fields? edit: right click each column and unselect SubTotal.

oddly enough, you just change this in the ribbon. There's a menu item in the HOME tab - Under Records section. (sigma) Totals. Just click it.

I strongly encourage you to wiki "Normalization" and read through the page until you feel you understand it. - Delete all your skill tables. - Replace fields in tbl_User-Skills with: User_ID (foreign key - joins contractor to skills) Skill_ID (foregin key - joins skills to contractor -...

Test bed for dynamically designed forms. Hand-in-Hand in my mind is manipulation of objects on existing forms. Currently, I have a form with Box1 overlapping partially with Box2. I'm attempting to allow a user to move Box1 behind Box2 when Box1 is clicked in Form View.

I've failed miserably at using names. :( I've the feeling that Controls don't have names assigned until post-processing that occurs when you switch out of Design mode. If you could provide a simple example that would be great.

Is there VBA code to select a control on a form that is currently in design view?

You could probably run a basic loop through the recordset? Pseudocode to add to a random button on a random form --- set Rs = currentDB.openrecordset ("Select ADNames From ADTable") Do While Not Rs.EOS strTableName = "t_" & Rs("ADNames") 'create table strSQL = "CreateTable " & strTableName...

paste into a button click. Set objDialog = Application.FileDialog(4) With objDialog .AllowMultiSelect = False .Title = "Please select a File" .InitialFilename = "C:\" .Show If .SelectedItems.Count = 0 Then MsgBox ("Action Cancelled")...