Search results

hello guys , i have a simple question and i hope to find a solution here , I Have Column named location which contains payment method (Bank "Then Bank Name)Or(Cash) i excel i used to do it as follows (If Location="Bank *","Bank","Cash") but in access i faced a problem in (*) i dont knw how...

Hey guys, I have a simple question, Can i link a linked table to database, To be more specific, i have a db named (data), i linked it to another db named (linked 1), i wanna to link (linked 1) to the third db (salaries), So is there any way to do that?

Hello Guys, I have an inquiry and i hope that anyone can help me, I have a database and i import another database file as a(linked table), My question is there anway to protect or lock the linked table only (in another way to be read only data) Thanks in advance

Hello Guys , i have this small database with a users table and form , also account numbers form , all i need is a tool in (Acc Number query & Dimmed Acc Number ) Forms in Cells ( Entered by & Modified by ) shows which user has entered or modified account numbers i attach the database to be...

Hello Guys , I have a question and i hope to find a solution here , iam working to create a database to help my in my work , all i need is i have a lot of companies codes in a table each company has a specific items for example (Xerox : Basic Salary & Meal Allowance &Incentive) if i create a...

Hello guys, I have a question and hope to find answer here, i have a query consists of around 50 column, when i create append or update query and start to select fields to uodate its only allow to append 36 columns. Is there any ways to increase coloumns numbers in the update query to able me to...

Hello Guys, I have a query with a data( employee name, bank name, company code) i wanna to create a report with a filter by company code and bank name.. To be more detailed i need every bank name to be in an individual report page. Is that possible

Hello guys, i wanna to ask you a simple question, I have a combo box consists of a data linked from a company codes query, i wanna to create a button when i click on it its open my main query.(which consists of alot of companies codes.) bases on the input i choose from my combo list. For...

Hello guys, i wanna to ask you a simple question, I have a combo box consists of a data linked from a company codes query, i wanna to create a button when i click on it its open my main query.(which consists of alot of companies codes.) bases on the input i choose from my combo list. For...

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...

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 ?

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...

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...

Hello Guys , I have 2 forms one called Reference , the another one named LCL , Iam just asking about how can i create a button in LCL form to add a new record ( with the data from LCL form ) to the Reference table . is there any code or macro could help me to do that task ? Thx

Hello Guys , i have the attached DB , ( FORM & Report ) i already have a split form and combo list which i already filtered by staff ID ( Macro is attached ) . now i wanna to apply another filter in report ( another filter with Final amount value , ) i mean when i type staff ID in combo list in...

Hello , I Have this data base i need help with some VB codes , i wanna to lock or ( make the Account number cell dimmed) while the clearance code = any value expect the default blank value for sure . any one can help with that plz . Another ask , we r 9 ppl gonna use this data base , is there...

Hello , I have an small inquiry about access security i have a database file consists of (tables , quries , forms and reports) i wanna to create one admin to be able to read and writy (modify) data , and create the rest of users to be in readonly mode , is that possible , please take in...