Search results

Hi All, I have just imported a class with an Error Handling sub in it from an Access Database into Excel. I tweaked the code a little so that it works in Excel, then tried to use that Error Handling sub and now am getting a comile error "Sub or Function not defined". I have checked for silly...

Hi there, I'm currently writing a procedure which opens a form and then performs certain changes to it, based on that procedure's arguments. I want this procedure to wait for the form's 'load' process to complete before it continues. Is there any way I can easily indicate this? Thanks

Hi all, I currently have a procedure that goes something like: NullString = "" For Each ctl In Me.Detail.Controls If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then If ctl.Tag Like "*" And IsNull(ctl.Value) Then NullString =...

Hi, I have three tables which each have their own uniqueID field that I really need to be unique across the three (for union at a later point). Therefore I have created a table which has two fields - an autonumber field and another indicating which table it lives on. I basically want to work...

Hi super-brains, I am finding that Access crashes on a line of code and I receieve the "Microsoft Access has encountered a problem and needs to close" type message. The offending line is: DoCmd.OutputTo acOutputReport, sReportObj, "Biff8", , True where sReportObj is the user...

Hi, I've tried searching for this question here to no avail, so sorry if this is a repeat. I have combo/list boxes with multiple columns and have no problems referring to columns 0 and 1 in VBA. If I try referring to any columns greater than this (ie 2, 3, 4, etc) however, it always produces a...