Hi, I need to design a ms access database (Office 2000), that will according to some data enter by the user, will create a "sql string" which will be send to...

Hi, Is there a a way to highlight the current on a Datasheet form? I use the "On Current" Event to open another form, I would like to "highlight" some how...

Hi, I need to open a text file if my code finds on the 3 Line (Always the 3 Line) the text "(FN-", I need to replace it with "(FX-" if the finds something...

On my Access App, I have a confict between the DAO 3.6 Library and Activex Data Object 2.1 Is there a way to change this function to a DAO? or anything else...

My search form as a subform (Datasheet view) that its source record is a query I have provided the user with several text field that they are use to filter...

Hi, I have created a Point of Sales software (MS Access from end and, MSSQL Express back end) The app is divided on pos_client.mdb, pos_manager.mdb and of...

If you create an appliction that uses ms access as a backend do you need to install ms access? Thank you all, Bre-x

If you have work 1 hour 30 Minutes How do you convert it to 1.50 And viceversa 1.50 to 1h 30m Thank you all, Bre-x

Hi, I have a csv file with the following content 2009-07-13,34195,1,CI000139,3,A When I import it into ms accesss with: 'Import Text File file_name =...

Hi, I need some help importing a tool list from Mastercam. Here is the Text File # = 1 Type = Center Drill Tool name = 1/8 CENTERDRILL Diameter =...

Is there a way using VB to reopen a DB , some sort of command button to "reopen" it? thank you all

Is there way that after a minute of inactivity closes a form? Thank you All, Bre-x

Hi, Using the control box toolbar I added a combo box. Now, how do I refer to that object on VBA?

How to you convert a date to a integer? Example 6/14/2006 1:57:37 PM to 1150308000 I have seen it on other languages like PHP Thnks for your help Bre-x

Hi, I am working on a Time Clock app for the shop employees. I need to now how to "round time" Example if the employee sing in between 10:00 AM to 10:30 AM...

Hi, I have a table that show Work Orders Columns: WO - Date - Part ID for each Part ID i need to query the 3 newest WO's (By Date): wo date part...

Hi, I found this code to insert a record into MS Outlook. It works fine. I have two questions: 1.- How can I insert a record into MS Outlook for each record...

I have the folling data on my table Part, Rev ABC, 000 CDD, 000 CDD, 00A DDD, 000 DDD, 00A DDD, 00B FFF, 000

How can I modify this function so that it will show what the record is? Function scan_sku() As String Dim rs As DAO.Recordset Dim strSQL strSQL = "SELECT...

I have a table with one single text field. S:\ENG\DATA\DWN\my file_1.pdf S:\ENG\DATA\DWN\CUSTOMER\MSG\file.pdf S:\ENG\DATA\DWN\CUSTOMER\My Subdir\my_other...