Cronk's latest activity
-
Cronk replied to the thread Solved Insert into hanging.If the field name is called Billing/Attorney, put square brackets around ie [Billing/Attorney] -
Cronk replied to the thread Subform for selecting multiple Employees to Associate with Project.I wonder why the people who are external have to have a separate table rather than being in the same table as Staff, with an additional...
-
Cronk replied to the thread Display last Record based on person.And all the work around solutions are all propping up "It's the current way they do it on the spreadsheet". Combining two or more bits...
-
Cronk replied to the thread Compare number of columns in Imported table from CSV with target table if are the same.If the import file is not linked, then the suggestion in #3 won't work. Another method is to read the first line of the csv file and...
-
Cronk replied to the thread Copy record from from to a table.Also debug your code to remove the compile errors ie missing With
-
Cronk replied to the thread Date into field after cursor leaves.That should also test that text box is blank otherwise the event will update the date to the current date whenever the field exit occurs...
-
Cronk replied to the thread Solved Accdb: Error Number List (see isladogs).I'm curious. Any reason why ? error (3211) Application-defined or object-defined error give a different, albeit less explicit...
-
Cronk replied to the thread Search table using calculated field..I still cannot see any point in generating a serial number just to generate a unique index when combined with the date. The example...
-
Cronk replied to the thread Multi Contractors on One Bill of Lading.Classic many to many relationship situation. One example here One table for bills of lading, one table for contractors and a third...
-
Cronk replied to the thread Search table using calculated field..I'm having trouble envisaging why you would need to know who was the fifteenth customer on a particular day. Or is this a way to...
-
Cronk replied to the thread Updating the front end on local server.Firstly, make a copy of the database if you don't have backup copies already. Then Compact/repair the database. That will probably fix...
-
Cronk replied to the thread Working from home with an access database over VPN.You could add sql server backend and pass through queries.
-
Cronk replied to the thread Solved Change name of Form instance in tabs.I've used multiple instances of a form in situations where the user is working on one record, and either gets a query on another record...
-
Cronk replied to the thread How to step through a table one record at a time.Maybe the OP cannot define the selection criteria for a query and wants to make the selection by "eyeball". In that case, I'd provide a...