Recent content by DreamGenius

I would be inclined to do this slightly differently, if you're more comfortable in Access: Rename Field 1 (First Name) as Full Name Keep Field 2 (Surname) as it is Add a 3rd Field, Forename Then, using an Update Query, populate Surname and Forename as follows: Surname : Trim (Right ([Full...

I think I've posted this sometime in the past but it might be useful again here. This is a simple routine that is fired on closing the database, when it creates a dated backup folder and copies itself there. I also set the database to Compact on Close in Tools > Options, which only works when...

Well, it was tad more complicated than I was looking for really. It did however set me off searching for something similar, which lead to this link. From that, I was able to develop the following code snippet, which appears to deliver what I was looking for:DoCmd.OpenReport strReport, acPreview...

I have a bunch of reports, all of which render correctly. One of them prints per the default Printing Preferences configured on my machine but the others do not; they override the settings. Is there some hidden setting in report design that I haven't found yet which causes this? Interested...

Okay, a little tenacity and a lot of Google appears to have solved the problem. I found this on another forum and changed my code to: Specifically ask them to close Excel Open a new Excel object Run the export Close the Excel object This appears to have done the trick. I'm not seeing any...

As a result of the issue which prevents updating linked spreadsheets from Access, I've had to completely redesign my import routine a requirement of which is Pass/Fail indicators after import to confirm whether or not a record was correctly imported or not. The process flow goes something like...

I'll tack this onto the end of this thread because the suggestion which lead to the solution to my particular problem came from here. In attempting to make my database compatible with Access 2007, I made: Public Function CurrentUser() CurrentUser = Environ("Username") End Function I then...

You're all but there. Your SQL string should actually be something more like this though:DoCmd.RunSQL "INSERT INTO Instance ([Instance], [Logout], [Login],[Event],stoppagetime) VALUES (" & Instanceid & ", " & prevuserdatetime & ", " & userdatetime & ", " & userevent & ", " & offtime & ");"For...

My client asked for spell-checking to be added on certain free-format fields and I was quietly squirming because I had no idea where to start. I bargained them down to what they REALLY needed, trying to buy time, not knowing where else to start. Thank goodness for this forum, its contributors...

This appears to be a long-dead thread but the answer to my problem was in here, so thank you to all contributors, and thank goodness for Search! I would like to think that the suggestion offered, of copying in only the uncorrupted rows into a new table, would have to be a soluton of last...

You should imagine a sheepish expression on my face as I post this. Simon's reply above has lead to a solution; I was looking for something somewhat more complex and therefore overlooking the blindingly obvious! My stumbling block was not really understanding Grouping in Reports. By Grouping...

In a word, no. I've tried and it's taking far too long to convert and I've already had warning messages. This was built in 2002 from the outset so I see no benefit in down-grading it, other than I won't be able to have your input, as I'm guessing you don't have a new enough version of Access to...

I'm out of my depth here. I don't use Access Reports as a rule because I prefer Excel, but this is what the client wants. I've built frmReport which uses controls for user input to modify SQL behind reports and gives users the option of running an Access Report, with less data in it, or an...

Dave Thanks but my challenge isn't the use of Distinct so much as the subquery comprising two joined tables because of database normalisation. I've even tried creating a temporary table to link to but, because I'm linking on two fields I think, it's still failing. This is frustrating...

Having used search, I'm deliberately adding to this thread because it isn't yet marked as solved and my issue is similar. I'm trying to update a Linked Table (being an Excel Spreadsheet) to set an Imported field to TRUE where I've successfully imported that record into the database. The...