Search results

There’s not 😔

This is the vba code for my button , shall i add that to my code

Hello guys , I have a button in a form which i use it to transfer data to appending query ( i mean when i click on my button the data in my form transferred to another form and query) but i face some problems and i hope to find solutions, when i click on this button the data transferred...

Private Sub Command197_Click() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Copy Of Refernce", "N:\001 ALL FORM2", True, "Adding new", "" End Sub

Iam sorry for being annoying, but iam still face some problems 😔

Iam sorry about the previous pic , here’s the screenshot

I follow the steps , but i dont know where’s the mistake , could you help plz ?

Hello guys , Could you please help me about if there any VBA code to append data from excel to access , i mean i have a table linked to form i need a button when i press on it all the data in excel file (in a specific destination in my pc) appended to this table , is that possible.

Hello guys , I wanna to know if i have form with a combo box ( contain alot of codes ) , and i have query with the full data of this codes , i wanna the vba code to a button when i click on it , which is filter the query as per the code i choosed from combo box , is that possible ?

no i mean by empty cells ( Overtime cell) that = 0 , i dont wanna it to appear if it equal zero or it is null

I mean by empty cells that the cells that doesn’t contain a company code , (CCF), how can i hide it , in another meaning i want to when i choose company code it shows headers fillling with (CCF) only .

Thank you guys for you replies , but i tried the 2 methods that you have mentioned but i still face the same problem , the filter working well , but it still showing the empty cells , is there anyway to avoid that ?

Hello guys , i have urgent inquiry , i have a table (attached ) I wanna to create form with combo box , when i select company code , it automatically filter the cells contain the same company code , for example , if i select CCF from my drop list , and go to query , i found the columns with CCF...

Hello guys , I have a small issue with external data from excel to access , when i append data , for example i added 50 record , when i check my database i found alot of empty rows with auto number , so when i try to add more records , i cannot continue with row number 51 , it maybe around 1k...

Hello guys , Iam just wanna to know if there any VB code can help me with the below : I have a database shared with my team (8 users) each one have his own username and password , is there any option to add a tool helps me to know this record created by which user , also if it modfied can i...

I really appriciate tour contionous support , and iam sorry for being annoying , but as per my info your code is only for adding a new record (maybe iam wrong) , lemme explain to you , i already have my data i search for ID using combo box when then i put a date in (PTS Date-Attached) all i...

Yeah that's excatly what i want to do , showing both of date and time , but please excuse my little knowledege in access , could you tell me where should i write "Now()" iam now in design veiw for my table . should i write it in a default value or which place ?

Did you mean i should use build a expression in this cell in query ! it's named PTS Date , may i press build and make it PTS Date = NOW() ?

i tried that , its only show date , not time .

Hello guys , I need your help with " how can i show time in a Date/Time format cell , i tried alot of soultions i found on internet , like make the default value = NOW() , and set "Never" in show date picker , but it's useless , so i have a form linked with query and table , i just wanna to...