Search results

I'm working on a timesheet database including addenda (additional budgets). each item is associated with an addendum, which is associated with a project. on my time item input form, i'd like two combos. one for the project, and one for the addendum. each record in my table of items is linked...

one way to avoid rogue instances is in your objects. anything you 'set' to something, 'set' to 'nothing' at the end of your code, in reverse order, so at the end of your code, i would add: set ExcelSheet = nothing set Excelbook = nothing set MyRecs = nothing it may stop leaving the instances...

I have some ideas on how to do this, and with which events to trigger it, but i want to hear other people's thoughts on it: I have a purchase order creation DB with a table of standard parts... about 350 items. orders can also include custom 1-off items, so i decided to simply add them to the...

i've been playing with the mid function in excel, and it works, sort of... i can search through, and it looks like the one that's creating problems is code 10: NL Line Feed, New Line ok, so i can take them out... but i still want to have the line breaks in there. what character should i be...

My plan was to write some VB code to go through each one of these fields and put the line breaks back in, but i can't find any way to find the squares. it's not an ascii character, and actually, i don't know how to search through the data one character at a time. actually, now that i think...

when i import a spreadsheet into a table, there's one column that contains multiline data. for some reason, in the imported data, hard returns (alt-enter) are converted into squares, and the line breaks are in new places. any idea how to avoid this? or how to go through programmatically and...

so simple, yet so smart.... i think i'd rather use that, since i don't really know what my current method does. i'm guessing it just passes all messages into that variable, but i don't know for sure....

What I really need to know is how to setup SQL Server to store my back-end database locally...

I've downloaded and installed the new SQL server 2005 express edition CTD (June ed.) along with the Express Manager. How do i get an access database into SQL server? Now that it's installed, what next? When i try to upsize, it asks me to choose a server, and gives 3 options, and i'm not sure...

Here's what was recommended on an excel help forum. i'm not entirely sure how it works, but i think it just filters out all OLE popups. I'll be trying it today.

Hmm... it looks like that would wait for the whole excel application to close... reading back now, i see i didn't mention some important facts... i'm printing anywhere from 1 to 5 reports from the same spreadsheet, so i need excel to stay open for more processing once the print preview has...

I've looked at that DoEvents thing before, but can't really understand its logic. the help file isn't very clear, either what i'm trying to do sounds... sort of ... like passing control to the operating system, but how will it know when to get it back? wouldn't that be dependent on what other...

this doesn't actually have anything to do with access, but the vba code would be the same if it were... and yes, i really do need the code to wait for excel. i'm exporting data from another program (solidworks, actually) and creating reports in excel. in my options form, i allow the user to...

http://www.access-programmers.co.uk/forums/showthread.php?t=87612 ok, my mistake. changed options to break on all errors. if i break only on unhandled errors, and use the following code: SQL = "SELECT qryRpt." & Forms!frmjbbkrpts.Form!cboFctr & " as [Medium], Sum(qryRpt.RevValue) AS...

found the problem... at some point i guess i decided to play with the options... (famous last words)... there's a little thing called 'break on all errors' that i seem to have selected, as opposed to the wiser, more relevant 'break on unhandled errors' which i'm pretty sure is the default...

Actually, i noticed in another module, my error trapping wasn't working either: http://www.access-programmers.co.uk/forums/showthread.php?t=87342 i definitely need to check my installation. i never thought of code outside the sub affecting my error trapping. i'll check that too. thanks.

you still don't understand. it never had a chance to evaluate that 'if' statement. the errror window pops up without it ever entering the errorhandler. the code would do exactly what i wanted it to do, if it had a chance to run.

SQL is a valid SQL string.... SQL = "SELECT qryRpt." & Forms!frmjbbkrpts.Form!cboFctr & " as [Medium], Sum(qryRpt.RevValue) AS [SumOfRevValue], Avg(qryRpt.RevValue) AS [AvgOfRevValue]," & _ " Count(qryRpt.Enquiry_Index) AS [CountOfEnquiry_Index] FROM qryRpt GROUP BY qryRpt." &...

I think you missed the point... you just changed what's in the error handler. it doesn't matter what's in there, since it never seems to reach it. my code was just for debugging to see if it was even entering the errorhandler, which it wasn't. the error popup is the access-created form, not my...

it's normal for it not to enter the error handler?