Search results

All, I have 75GB worth of data that I'd like to add to an Access DB. Obviously, Access DBs can only be 2GB in size so just having a back end with 75GB worth of data is not an option. I don't know anything about SQL server or anything related to that. Does anyone have any examples or...

All, I have a split database, the back end is password protected but the front end is not. I protect the front end by disabling the shift + open option, disabling F11, removing the ribbon, all menu buttons, and there's no right click function. Basically the users only see the forms I've...

I have a form with a web browser control, path is to Google API static map website which marks lats and longs. This form has a subform which has multiple lats and longs which I'd like to map in the web browser control on the main form. Any ideas?

I'm working with a password protected DB and can't debug the code using the ctrl+F8 feature. There's probably a simple fix this so does anyone have any suggestions?

All, Is there a way to disable the ability to Import and Link the BE of a database? I've added several security measures to the FE and BE but all the information in the BE is still easily accessible if the user makes a new database then links or exports the tables. Can VBA disable some of the...

Hello All, I have a calculated field which is based off a text field which can contain text values and numeric values. I'd like to add a statement in the criteria which performs some action if the value is text. IsNumeric is not a function I can use in expression builder so I'm thinking of some...

All, I've converted the Projects web database to a client desktop version. The web version allows for tracking in the project history table based on the log in ID through the internet. The editor is not tracked on the client version. I'd like to add a field in the table "Project History" which...

Hello All, I've developing a QA/QC database for testing chemical products and I'm stuck on the best way to continue with adding multiple records by using one form. I have two tables: tblProductSpecs with two primary keys, "ProductName" and "TestName" tblResults with three primary keys...