Search results

Hi All, I have been working on this problem for hours, but I keep hitting a brick wall! Basically, whatever date is entered in [field1], I want [field2] to return a date of the 15th of the following month. For example:- 01-02-2007 = 15-03-2007 31-08-2007 = 15-09-2007 23-12-2007 = 15-01-2008...

Update. Hi there, After a bit more testing, I have found that if the database is split and you ESC during a compile (whilst in the FE) the data remains intact. But when ESC during a compile in the BE, it deletes the data. Moral of the story: Split your DB's and only compile the FE...

Hi Gemma-the-husky and, no, you are not intruding! Basically, if you checkout my attachment, the DB has one table. Open the table and look at the record count at the bottom (ignore the auto-number). After hitting the ESC key before compact has finished, the table count is reduced. Sorry to...

Hi DreamWeaver and thanks for replying. Here is an example. I have attached a DB which has one table and over 100,000 records. Manually start the compact and repair then hit ESC quickly after. Records are missing. Just noticed that a table is created called MSysCompactError. Regards, Paul.

Hi there, I am having a similar problem Dyonn had with regards to deletion of data when compacting. What hppens is that if I check the COMPACT ON CLOSE option, compacting works fine when the DB closes. However, if a user hits ESC before compacting has completed, a particular table looses...

Marcello Lippi!

Thanks for replying Friday. Am currently looking at a possible codec/compression issue at present. I did download Avid. Apart from it taken about 5 minutes to load everytime I fired the application up, it re-configured my keyboard and finally changed all my Access desktop icons to PC looking...

Hi folks. I am hoping that someone may be able to help me with a problem I have regarding AVI video files, or point me in the direction of a good resource site. I have an AVI movie file saved on my hardrive which I captured from my Canon MiniDV camcorder using the Ulead program. If I playback...

Thanks to everyone who has helped me on this. I am in my early stages of writing SQL and thanks for your patience. I have managed to get this working now but have a final issue that needs addressing. The following code works correctly:- Dim DB As DAO.Database Dim Rc As...

Thanks very much Ken. I will try your suggestion tomorrow at work. And thanks for the sql writing tip. Paul.

Ken, Sorry. To populate a form. Paul.

Ken, The form has a 'start date' and 'end date' fields. The query is run based on the data in these fields, hence the BETWEEN syntax. Paul.

Thanks Ken and Rich for replying. I am trying to run a select query based on two fields on a form. I'm not sure if the BETWEEN syntax is correct. I have read that I think you need to enter the word PARAMETERS right at the beginning of the statement but don't know how. Rgds, Paul.

Hi there, Having problem with this parameter query which works off of a form and don't know how to resolve. Error being:- "Run-Time error 2342...A RunSQL action requires an argument consisting of an SQL statement." Dim mysql mysql = "SELECT tbl_pallet_log.ID, tbl_pallet_log.Entry_Date...

The txt files are FTP'd from our stock control system and the data is displayed as per my example - with different rows of address lines. I usually run an excel routine to fashion the data as I want it, however, I am only limited to 65,000 rows. Sometimes a report can be over 250,000 rows long...

Thanks for replying Rak. I have attached an example DB to explain the problem a bit more clearly. TABLE1 is the imported data. In QUERY1 I have added your RIGHT expression and also an ISDATE expression which would summarize the data onto one line. I only need this information to appear, but...

Woops!. Sorry about that. My file exceeded the 100kb so had to make smaller.

Hi there, I have attached an image of a table which contains order details which has been imported from a txt file. I require the postcode (in the customer column) to be transferred to the postcode column next to the despatch date for each order. The address rows can vary but there is never a...

Hi there, In Excel, I use Application.EnableCancelKey to stop a user from interrupting a macro whilst it's running. Is there an equivalent piece of code in Access so that it stops a user from using ESC or CTRL+BREAK to stop/interrupt a code from running? Or can someone suggest an alternative...

Hi there, I currently create my treeviews by hardcoding the node structure in vba. I'm at the stage where I would like to create treeviews based on data held in a table, which I believe are easier to maintain. Does anyone have a link to a good tutorial on this, please? Also, looking to link...