Search results

check this http://ss64.com/access/browseto.html

use Trim() function to remove spaces from any field entry in the database. check the attached file with trimmed query. Trim([FieldName]) in this case: TrimmedOrg: Trim([org_Name]) cant upload .rar file. this form support only zip file to be uploaded. anyhow create a blank query and drag and...

Are you using Ms-Access 2010? did you compact and repair the database? sometime it happened when you converted 2003 database to 2010 and if you compact and repair the database the Autonumber seeding get corrupted. This happens in Access 2010. I am not sure if you have the same problem. Just try...

Agreed and thanks :) It's always recommended to simplify things before evaluation.

Good you sorted it out, the deleted record should clean up automatically whenever you open the table again OR there should be Re-Query action after every deletion on the form. AND again WHY deletion is allowed by users for any record on distributed database?

The problem is solved by running the AutoNumFix function already posted in the thread and adding PRIMARY key to all the related tables corrupted for auto number seeding.

you are welcome fsmith, just keep in mind some basic rules always - avoid duplicate information i.e information should not be repeated while designing your tables - every table should have primary key (even its not necessary, but good for relationship) - keep primary and foreign key concept in...

How much time consuming if you refer the control in VBA while working with SQL? is there any extra load on database engine while evaluating the expression by passing any reference? When the control "TextBox on a Form" should / should not refer in expression?

Is your form "EventList_Justified" is underlined to the specified Query/Table? Suggestions: 1: Try to compact and repair database. 2: Check if your Text41 is named correctly Text41 3: OR just re-create the Text41 and reference the same name to your code 4: Insert Break-points in VBA editor...

Mr. Peter is right. any SQL statement will just work as string for any query. The better way to any string statement in VBA is to create a query in the QBE and get its SQL in the editor. You have to take care of the parenthesis and braces in the VBA code editor to call any query correctly.

for this you need normalization of data, study more about how to normalize data, relationship and data integrity.

did you change "EN Number" field name in the BE mistakenly?

Create a blank form: Step -1 Click create >>> Form Design Step -2 In form design, click on the command button on the design menu and then click on form design surface, click cancel button. Step -3 double the command button and open the VBA code design window Step -4 On button click event, copy...

Our company have more then 10,000 pcs and they change the whole system to 64 bit version company wide. I don't know the exact cause of the problem why it happened? I re-studied the whole database and fixed the problem by just introducing PRIMARY KEYS to all the tables in the database. I...

Re: How to fill "Local Tables" with Password Protected back-end database tables I dont have the SQL BE, I have shared database file. This file is shared by lot of other applications on the network, one of which is REPORTING application where we need the latest data to print. Reporting...

Re: How to fill "Local Tables" with Password Protected back-end database tables Thanks Michael Lueck and Trevor Actually I required to get all the linked tables data in one of my Reporting front end application, where we can print reports based on lot of complex queries and different reports...

Hi everyone! I want to fill local tables in some application with disconnected recordset. The tables in the front end application having the same table structure as in the back end database. The front end application was linked with the back end password protected database tables. I want no...

Hi dear, how are you and where are you now a days... do you have facebook id?

The air code should be like this. It would be better to understand if you could paste your code.

Hi, what code you are using for the correct password? how do you confirm that the password is correct? Is your form is subform on main form?