Search results

Round down to multiple of 5 .....round down to the nearest five ... ie. 554.43 to 550.00 557.76 to 555.00 etc try this ... NewValue = 5 *int([OriginalValue]/5 ) HTH

DAO.Recordset? I saw this post from Mailman, and thought i'd give it a go, as it seemed useful. Ben, If you remove or comment out this line Dim rs As DAO.Recordset It will work. Though i don't know why/what the DAO bit is about. One thing i noticed, for some reason the line numbers are...

Append type query Select an Append type query. To do this ... bring the new table into a new query. Then select Append query type from the selector next to the ! run icon and choose the table name where you want the data to go on the drop down. Then match up each field between the source...

I agree that it doesn't seem to be an import problem as such. If you import the data into a fresh table you have no problems. It seems to me that you are trying to populate a new database. It could well be a relationship problem, but you could try this ... Get the table imported as a fresh...

Adjust format JediDG Make a safety copy of your table then try this. Go to design for the table and select the autonumbered field. In the lower option box select format and choose General Number (you'll see in there that one of the options is scientific). Close and save the table and check...

Inadvertantly set a format, possibly This part is down to formatting only. The 1E04 is scientific notation format and means 1 times 10 to the power 4 ie 10000, which is the closest approximation to 8067. At some point in your process you may have inadvertantly set a format, possibly. As to...

EMP Thanks for clarifying my post. Cheers.

Include field names Including the last two parameters allows you to say to include field names in the export (true) so provided your access table fields are correctly named (you could change these as part of your query, if needs be), you can use the following: DoCmd.TransferText acExportDelim...

Bit of a fudge but gets there I don't know a smart solution to this, but you could do the following (much as you were suggesting): Importing into access, set 'first row contains field names' to TRUE. Then delete the first row in the table,save and export with the setting 'include field names...

Job done Thanks, Rich. Did the job. Cheers.:D

I have been trying to use the No Data Event, initially with success. If my report contains No Data, then it does not display anything on screen and I can organise a "No data" message to confirm this. Fine. However, I want to have the option of displaying/printing the blank report for...

Warnings on and off "....the warning boxes appear.....is there any way that i can shut these off?......." DoCmd.SetWarnings False .......'Turns warnings off Your query/s in here DoCmd.SetWarnings True ........'Remember to turn them back on (you may want them on elsewhere)

Date Serial (cont) Pat Hartman, Thanks for some helpful comments, inc. re: dates in ccyy instead of just yy format. However, all my dates are in ccyy format. The problem I am seeing is that the date (dd part) seems to be being reflected directly into the yy part of the result: "If DateOfBirth...

Date Serial : Query vs Module I have been experimenting with the DateSerial function (using Pat Hartman's 'usefuldatefunctions' posted here recently) using the two methods below: I get different results! If DateOfBirth is,say, 29/09/2003, SQL gives me 01/09/2003, but the module version gives...

Same but different Sadly, no solution but consider this... I've recently had a similar 'long opening delay' on a small db i was developing to go on an Access 2002 machine. I use Acc2k in the office. After i did some work on the db at the clients pc i took a copy to load back to my PC. I don't...

Assuming your data is stored in the order entered still then could try this... Add an new field called, say, fred as an autonumber field type. Then run a query using the Group By /Zigma/Totals function and just have your account number as Count with Max function on autonumber field (fred). This...

This will work, though its not very elegant... Original table Customer, Table2 is the new table. Copy Design of customer as new table Table2 and add a new field called say, RowCounter and set the field to Autonumber. Add two junk records to this table2 and then delete them. (Now the...

Pat/Len: I've just tried this DELETE tableA.field1, * FROM tableA WHERE (((tableA.field1) In (Select field1 from [tableB]))); This works fine, and neither table has a pimary key or indexed field. Thanks for your help. Now i can die happy... or at least have a stress-free week-end! :D

This should be easy, surely This should be easy, surely? I'm having the same problem as Vassago, namely trying to delete one record from table A that is also in table B. I have tried the suggested solutions with no success, I either get 'recordset not updateable' or something along the lines...

Yep, did the trick. Thanks, Waltang. I agree that 'This does not however fix the problem if someone browses to the database to open it'. I was wondering , if all one's Acc97 were located in the same folder as the Acc97 software installation itself, and Acc2k databases were in the Acc2k...