Search results

Hi all, I wanna export all tables beginning with NEW_TRP . Blank Tables shouldn't be exportet, therefore I tried to delete them before. Somehow my check it the tables are blank or not doesn't work out. It still exports me all tables of the database. Can someone give me a hint please? Thanks...

Thanks Paul, this was the solution. You rescued my day. Thanks.

Hello JD, thanks for your hint. My issue is when the user types in the date 01/03/2014 in the InputBox and I assign this to the date variable startdate = Inputbox. How can I use this startdate later in the SQL Query?

Namliam, I defined the variable startdate as Date. startdate = 1/3/2014 I don't understand your comment inserting the # within the query. What do you mean with that?

Thanks guys, it works out with t = #1/2/2014# and Where TRP.[Valid_from] > " & Format(t, "\#mm\/dd\/yyyy\#") I tried to assign a date to a variable startdate given by the user as 1/2/2014, somehow it doesn't accept this startdate later in this subroutine. Any idea how I can resolve this?

Thank you so far Namliam, I've read your suggested thread and tried this: Dim t As Date t = 1 / 2 / 2014 DoCmd.RunSQL "SELECT TRP.Customer, TRP.Material, TRP.Product_Class, TRP.TRP as TRP_in_EUR, TRP.Valid_from, " & _ " TRP.Valid_to INTO [New_TRP_Witten] " & _ "...

Acutally I got a table TRP with a date column Valid_from, containing records with e.g. Valid_from = 02.01.2014 (for 2nd Jan 2014). I want to decide the user which date he wants to see, so I need a date variable t for example. How can I select for these records in SQL ? Thanks in advance.

Hi all, I want to create a table via SQL. This table should contain records that begin after a specified date. Something is wrong with this syntax. Can someone please help me out here? Thanks in advance. Regards, Ben Sub TEST() Dim t As Date t = 1 / 3 / 2014 DoCmd.RunSQL "SELECT...

Hi Paul, there was no special reason for that. In the meanwhile I found out that an usual link to this table will also work out for me. Thanks. Regards, Ben

Hi all, I try to update a table with a table from another database. Somehow it shows me this error message: Run-time error '-2147467259 (80004005)': [Microsoft][ODBC Microsoft Access Driver] The database has been placed in a state by user 'Admin' on machine 'xxxx' that prevents it from being...

Thanks to all your replies. My problem was related to the calling environment, I've changed the position where the Delete Statement is calles, now it works out. Thanks again. Regards, Ben

Public Sub DELETE_QUICK() DoCmd.SetWarnings False CurrentDb.Execute "DROP TABLE INCOMING_Orders_REPORT", dbFailOnError DoCmd.SetWarnings True End Sub

Thanks for the hint. I tried both ways with DoCmd.SetWarnings False and CurrentDb.Execute "DROP TABLE INCOMING_Orders_REPORT", dbFailOnError. Nothing helps, it still shows me the warning message.

Hi all, although I wrote: DoCmd.SetWarnings False Somehow I get the following warning message: The existing table INCOMING_ORDERS_REPORT will be deleted before you run the query. Further under Help it shows me : If your intention is to create or replace a table, click Yes. To avoid being...

Hi all, I found out that there was a data inconsistency, created by a colleague here. So I do not have to change anything in the code. Thanks. Regards, Ben

Dear all, I got a weired issue here. There are two reference ids in the original table: Ref No. Price Customer 434121 101,471018 A 434121 101,471018 B Now after some calculating (withount any known roundings from my side) ıt shows me this ın...

Dear all, I got a weired issue here. There are two reference ids in the original table: Ref No.

Thanks for the hints. I corrected this, however now it runs into a never ending loop, showing me the error message "Reporting rep_date is not in the correct format = mmyyyy" Public Function RepMonthCheck(rep_date As String) as Boolean If Len(rep_date) <> 6 Or Left(rep_date, 2) >...

Dear all, I would like to select a case depending on the output of a function. This function tests the syntax of the reporting month. If the syntax is fine nothing should be done further in the main sub else it should return to the Input window for the reporting month. Somehow it doesn't work...

Thanks JHB, this will definitely help me, I will use this. Thanks. Regards, Ben