Search results

Hello All, I have field as a string 2022-07-06 01:54:44.000 2022-06-10 20:43:59.609 1- I want to remove after space ( 01:54:44.000) 2- change the 2022-07-06 to date format how can I do this in Access query ? Thank you

Hello I have two tables with the same structure and data . I want to have a query to update only records from table2 from table 1 where changed . both tables have the same fields

Hello I've added this line in my macro to ask user to input the date. It repeat two times in my macro .!! I 've changed it many many times .but ... .I have the same code in another database which comes up one time ! could you help me what is wrong ?( the correct date should be 2022-01-01 ...

Hello I have this small VBA code which is appending data from one table( that is selected in the list ) to other table with the same fields and name. Private Sub Command2_Click() Dim sVal$ sVal = Me.Combo0 sVal = "INSERT INTO OSFinal " & _ "(...

Hello I have a table with two fields ( date and flag) I need to find the max Month no. then update flag of the records with 2 months older than max month . ex ; 08/01/2021 then max month is 8 update flag for records with month less than 6 could you give me a hint how to do ...

Is there a way that I can have a form in Access show the user a list of the tables that are in Access as a drop down list? What I want to do is let the user view data based off the actual table it is in.However, also don't want to show ALL the tables, just ones with a name prefix like "Data_*"...

HELLO I have a databse with a table to give access user to login .but it have an error that i can solve it ,anyone can help me to find the issue ? Private Sub Command1_Click() If IsNull(Me.txtBnumber) Then MsgBox "Please enter your Bnumber to proceed." Me.txtBnumber.SetFocus Else...

Hello I have a basic question, I have a table and want to compare dates .if date 1> date 2 , then pop a message . any Idea how can i do it ? with query or with VBA ?? Thank you

hello, I have a quay to group by 3 field and do sum in other fields . I want to have two other fields but not to be group by I want to be a part of table but i face the below error. how can do that ? any idea ? I appreciate for your help

Hello I need help in concatenating a string field in rows : I want to do group by AC Model and Ac Serial,then concatenate all AC event text strings for it together. Can you provide me a solution ? Thank you

Hello I need a help in sum of some fields I I want to sum (p and s and un fileds) id the month is 8 and add in O field? when i write id the query ,i have a lot of errors Operation_SUM : IIf ( Month([MONTH)]) ="8",([PLANNED]+[Scheduled]+[Unscheduled]),0) Could someone help to do this query...

Hello I have a query that shows the correct details. it should show 12-month data before the exact END DATE from exiting data . for a specific case,I have just 2 2 month records to show. How can I add a condition if the other months are not on the list put their value 1 or 100%. this query ...

Hello I have two databases,1and 2,I want to run a macro from database 2 in database 1 : I have the below code, but not work and no error .can you hint where is the issue? Public Function run_main() Call CallMacro() End Function Public Sub CallMacro() ' Dim strDbName, strMacro Dim...

Hello I am new in VBA, I have a scenario to import 3 excel files that have the same sheet name ( all 3 have "Report details" sheet) , I want to open a dialog box and choose 3 excel files at the same time and then make a copy in a folder of them .and then import all 3 sheets in ONE table . what...

Hi I am trying to import an Excel sheet to access table and i find the comments section being truncated.I changed the data type in table to long text ( Rich text) .but it truncates less than 255 char. My DATA table has two fileds with longtext( Rich Text) datatype. can you tell me which part of...

Hello I have a table in oracle and I linked it to my access. then I can open it and see data. I created a simple query to see records with the criteria "del" in one field, the below error comes up when I run the query !!!! Could you help me with what would be this issue? ODBC -- call failed...

Hello I need your help, I have a table in which some records have been duplicated .based on one field ( ex. Id ) I need to change the duplicated Id ( ex . add -1 at the end of it ) how can I do it in a query? how can ask to find the duplicated records and change the id ? thank you in advance

Hello I need your help ,I had the below code for Export 3tables in Xl format in a folder .it was working perfectly ,but after updating Access 365 I have runtime error 91.. in the line " For Each varFile In .SelectedItems "... can you help me to solve it .thanks alot Public Function export()...

Hello I need help,I have a table in which one field is populated with numbers , I want to truncate this filed to 5 digits( some numbers are less than 5 and some are more). for this field, I want to put a condition if it is greater than 5 digits, delete the rest of the characters( I mean if it is...

Hello I have the below code to delete a table if it exists, but it doesn't work could you help me where is the issue? If Not IsNull(DLookup("Name", "MSysObjects", "Name='JIC Global'")) Then DoCmd.DeleteObject acTable, "JIC Global" Thank you