I have 2 tables with part number and description fields with more than 45000 rows each. i need to select the describtion from table 1 that matches desc. from...
Hi, mikeuhd! MS Access is, as you probably know, relational database program. Word "relational" means that you could certainly relate your 2 tables by making a...
dears, after precessing my table i have one query field like section name,no of job pending,no;of job received, no;job finished. but when running the query and...
I have a part number field with numbers and characters. for example i have a part number 457-67a/12. i want to repalce the ,"-" and "/", with empity string...
Hello. I am using Access to link to my accounting system table through an ODBC driver. I am just pulling a simple query of vendor name and number. I then...
May be you can try this: Replace(Replace([PartNum],"-",""),"/","") I hope it work. ... From: mikeuhd To: ms_access@yahoogroups.com Sent: Saturday, November 10,...
please copy your sql statement in your query and paste it here. We will see closer to the problem Regards, Edy Indonesia ... From: Muhamed Faisal To:...
dears, hope any tips from you for the following problem I have one database on ms access and by using security wizards(user level security wizard)i convert the...
the idea is using recordset. I 'm not testing it yet. May be you need correction in sintax put it in your module. Function GetProject (byval EmpID) as string ...
Faisal After securing your database with the security wizard there's workgroup information file created with ".mdw" extension. When copying your database...
Dear Liveson, On securing our data base by using security wizard there are four file is genarating including one shortcut and if i want to open this database...
Hi Faisal Make sure you copy the original database and the ".mdw" file. Don't copy the short-cuts (often with ".lnk" extension). Paste the copied files in the...
... There are two ways to do this. The first and simplest one is to generate a report and group by "EmpID". The second one is a little more complicated and...
... There are two ways to do this. The first and simplest one is to generate a report and group by "EmpID". The second one is a little more complicated and...
... There are two ways to do this. The first and simplest one is to generate a report and group by "EmpID". The second one is a little more complicated and...
Dear Liveson, thank you for your reply but it didn't solve my problem ,I copied all the files generatore after securing the database I am using access 2000...
Dears, I have a query in which there is a date field and a quatity field ,i selecting date by using text boxes in one form,now i want to make one query with...
Janet The maximum number of fields in one table is 255. Regards Liveson ... From: janetc2_1999 To: ms_access@yahoogroups.com Sent: Thursday, 15 November, 2007...
Thank you, Liveson. My problem is this. I inherited an Access database at work which was created by someone who doesn't really have a DB mentality, for...
dear faisal AOa result of query depends on the relationships. The query may return no records even if you can see these records in the tables individually. One...
Dear Janet, Any table with that many fields defined is too wide and needs to be broken down a bit. Below is a small table with the characteristics of an Access...
Hi Janet As Peter has said in his email below, having all those fields in one table is a sign there is a problem with normalisation. I won't be surprised to...
Please help; I need to retrieve the filename and date modified from a windows directory/subdirectories and store them in a table. The idea is to add a field...
One way is using the FileSystemObject. Add Microsoft Scripting Runtime on your reference and click the Object Browser to see all the syntax. HTH, George ... ...
I'm sure this has been well covered here but it's tough getting through thousands of past questions or the MS site. I'm a new member and new to Access apps...
You can use the OpenArgs... from your double-click procedure, you can put this: DoCmd.OpenForm "frmYourFormName", , , , , , & me.YourID on the form load of...
I would like the user to be able to click on a "New Record" button and have it put a new record in the table with a few predefined fields including the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
