Search results

Hi to all I need your help. I have 2 tables Material_IU and Material I want to read all the records in the table material_IU and if the records exist in the table Material perform update else perform insert. I have to work in access 2003 about 5 years and it is very urgent.... Thanks for...

Hi to all. I have in my table a field called 15_17_flag This field take only 2 values. "15" and "17" I want if the field has value 15 to show in the form in a work field "Value 15" if has the value 17 show in the form in the same work field "Value 17" How can i do this. Thanks and regards.

I'm try to return some values from a record in my access database but i can't i use this code Private Sub Find_Desc_Quan() Dim con As ADODB.Connection Dim rst As ADODB.Recordset Dim sSql As String sSql = "SELECT * FROM Material WHERE ITEM_BARCODE= 1234567890" Set con =...

Hi to all. I have 2 forms. Form-Header that takes the data from a query Form-Detail that takes the data from table. I want to know if it is possible when i close the form-detail (the form-detail open from a button in the form-header) make requery in the form-header and show in the first line a...

Hi to all I have a continues test form. The form is able to show 20 records My table has 52 records. Now let's say the form show from record 22 to record 41. The user open a subform at record 31 for example I want when the subform close and after the requery the first form show again the...

Hi to all. I have a form with 3 date fields. If the last date field is empty and the mibble date field is date then on exit a add XXX years in the last field. The point is when the last field take the focus i'm not able to read the date because the whole field is black. If the specific field...

Accept only upper-case letter Hi to all I want when the user type lower-case letters convert to upper-case letters After some dig in the internet i found this KeyAscii = Asc(UCase(Chr(KeyAscii))) on the keypress event where it works great for English characters BUT when i type Greek...

Hi to all I want to add a color box or whatever you think is easyest and when i open a form in every detail line read from another table and if the date diff is less than 30 days change to orange and if the date diff is less then 10 change to red. Any idea how i can do something like this??? I...

Hi to all I have this sql sSql = "UPDATE GUN_D SET GUND_DATEAPPLICATION = #" & Format(W_GUNL_DATEAPPLICATION, "mm/dd/yyyy") & _ "#, GUND_RELEASEDATE = #" & Format(W_GUNL_RELEASEDATE, "mm/dd/yyyy") & _ "#...

Hi to all I have an access 2003 database where the table is linked from mysql. I would like to know how it is possible to read a specific record from the linked tables using vba code. Thanks

Good evening to all. I would like to ask I have a database in Access 2003 that works without any problem for over 3 years. I tried to break a copy of the database and to convey all the tables (without the relations between them) in mysql and access have only the link of the tables. The...

Hi to all I have an access 2003 database where the tables is in mySql and i have import the tables thru ODBC Is there any way to split the database? (When i'm try to split my database they said that there is no table in this database) Thanks

Hi to all I have a huge problem I use this sql ( sSql = "SELECT capacity_pieces_sec FROM capacity WHERE capacity_material_code= '" & bkpdwnH_material_code & "' and capacity_machn_code= '" & bkpdwnH_machn_code & "' and capacity_number_employee =" & bkpdwnH_number_employee) but my last field...

Hi to all. i have a table name tbldamages (Damage_id, Damage_Desc, Machine) In some record the field Machine is null I also have a form with 2 combobox machine and damage I want in the damage combobox if the machine is not null to bring me FIRST the Damage_Desc where the Machine is equal (to...

Hi to all.... I have a form that normally show 10 rows. In the after insert event i use the DoCmd.GoToRecord , , acNewRec to send the curson to the new record. after running the command (DoCmd.GoToRecord , , acNewRec) regardless of how many records I have i see only one (the last). How can I...

Hi to all I have a form and i want to move the cursor in the new record. i use the command DoCmd.GoToRecord , , acNewRec The command work great but my problem is this. When i run the command in my screen i am able to see only the new record. To see older record i have to press page up Is...

Hi to all I face a problem after some changes I make in the Switchboard. The changes: 1)I have 3 tables for the switchboard Switchboard_Items_1 Switchboard_Items_2 Switchboard_Items_3 For three different user (In the beginning the database open with a form that ask for user...

Hi to all. I think that i have a very simple question...... I have a (header) form with 4 fields and a (detail) subform with 7 fields. I want the user if he left any field in header form empty before fill any field in subform receive an error message and the empty field receive the focus...

sSql = "UPDATE Customer SET Customer.Customer_Rest = " & W_Customer_Rest_After & ", Customer.Customer_Total_Income = Customer.Customer_Total_Income + " & Rent_Final_Price & " WHERE Customer.Customer_Key=" & Rent_Customer_Key W_Customer_Rest_After=50 everything is ok Rent_Final_Price=125,75...

Hi to all I'll try to be as detailed as possible. I have a form in Access 2003 like this Descr_____Pay_____Rest_____??????? Machine1__100______20_______20 Machine 2__100______5_______25 Machine 3__200_____30_______55 Machine 4__200______0_______55 Machine 5__300____100______155 Can someone...