Search results

Use the "SumIF" function is Excel. This question is posted in the wrong form.

I can do work remotely.

If there's any VBA code in the reports, (1) compact & repair, (3) recompile; (4) check the recordsource for the slow reports as a huge number of rows (100Ks) or (4) a local table linked to a linked table can each slow down opening a report.

You could use a table as the subform recordsource, forcing the same number of rows and columns to always appear which would be editable.

I rent 20G from Apple's iCloud.com for $0.99 a month. The only problem I have with it is sharing data on multiple PCs, i.e. when adding a new folder on 1 PC, other PCs fall out of sync and do't always get the new folder. It's my understanding that it's a known Apple problem with an easy manual...

Get yourself some cloud storage for sharing a back end data base (Apple's) iCloud or OneDrive, they have free space as well and very low cost space.

Remember Access tables are not specifically ordered, but order row comes form column characteristics. Of course, every table has a first row, i.e. a first dataset row, it may not be what you expect. What are you expecting in the first dataset row?

I can't tell what's going on with the information you've provided.

Use the FilterOn, Filter properties for you form. Create you Filter property based upon which, either or both you filters are populated and set FilterOn = True. Note on the form_load event, set FilterOn appropriately.

Note that the data type of imported columns is determined by the data in the first row imported. I suspect that your column is of an improper data type.

Gotme. I misspoke, Galaziom. I was thinking of another concept.

What event initiates such movement and to what location? Assuming that you have that figured out, adjust the controls' Left and Top properties (in rasters, inches time 2400) to the requisite new position.

Use the Detail section onfomat event to set the colors you want, alternatively use the conditional format icon on the ribbon..

You have to create another column in your report recordsource creating a duplicate row number. Access won't do it for you.

Are you sure that the form has an updateable recordset? With 2 joins in your SQL, I doubt that it is.

Unless you're linking the Access data, that is, importing it, how could the Access data change?

Silly me, I didn't try to enter on. Otherwise, the form looks goods and is ulitarian. Note that there a good couple videos on YouTube that explains how to secure a database, including encryption, which you should consider since "password crackers" are generally available. Goog luck.

I use DAO recordsets exclusively with Access.

You go to a lot of trouble to attempt to move move staff from one table to another, which could be done with simple SQL statement executions and a requery of each subform, e.g. 4 lines of code would to it in DAO or ADO: Update record in Assigned table Delete/Modify/Tag record in Available table...

Isn't it prudent to be certain that all rows in a column to be imported to be of the same data type. Fix it on the Data side or on the Excel side.