Search results

Well, I think I got it figured out, one of my entries is dividing by a sum, and in some rare cases that sum would be 0. Which would be a divide by zero, and instead of throwing an error, I think it was just not returning results after that. So now I do a <> 0 for quantity, and that seems to...

Hi, I've got a listbox which is being used to display some data. When I hit a button I want it to resort the data its displaying. I do this with the "ORDER BY" in the query as below: SELECT item_id_est, descr_est, mtrl_itm, size_itm, Round(Sum(quantity_est),0) As 'Quantity', um_itm...

I have some cache tables that I treat as temporary tables and run a lock on to avoid more than one user attempting to load to the table at once. They're only used for the rare import from xls command, but I dont know how I would manage it with a query.

I dont know what could be causing this, but in my projects I've preffered to create my own identification number rather than using an automatic. My insertions don't tend to be too high ussually, so I use a random number and check it before inserting. If you have a high enough ceiling though...

I'm trying to pick up work on an on again off again project that hasn't seen the light of day for about two months. Its running off of a microsoft desktop sql server, and recently something seems a bit out of order. My interface doesnt' seem to have any problem getting data from the tables...

well, seems to me you have some syntax issues to start with. sql = "INSERT INTO Error_handling_table ([Error_Number],[Error_Description],[Error_Location] ) VALUES ( '" & lngErrNumber & "' ,'" & strErrDesc & "' , '" & strWhereFrom &"') " DoCmd.RunSQL sql thats the way I do this typically...

Thankyou, the vba version of isnumeric works great.

I have a function which is reading in numeric values from a large excel spreadsheet into access, once I get everything in, the function sorts them and updates the apropriate tables and values. The problem I'm having is that some of my users don't always follow the rules on values and will put...

i did something similiar to what you're doing, and handled this by recursivly calling the same function when i hit a duplicate. Function insert_record(contractor_id_mTBL As Long, job_name_mTBL As String, contract_number_mTBL As String, region_mTBL As String, labor_mTBL As String...

ah! thankyou very much.

I'm making some lines with me.line, and I'd like to change the thickness they're being created as to match lines already on the report form. Is there a way to do this?

The acess 2002 Desktop developer's handbook suggests using Packaging Wizard which is included within Microsoft Office Developers. It creates a packaged product which would install both your database and a runtime only version of access for the user to use. You'd be wise to limit user acess to...

Ah, well thats too bad. Thankyou for answering.

I'm trying to duplicate an older paper format where the title of a grouping was listed in a vertical bar along the side of the group. So far I haven't been able to get access to do this, the books I have only explain things in a horizontal tiered system. anyone know how to do this or if its...

Ahh, thankyou very much. While there was ussually a better way to do what I wanted, not knowing if that was possible was bugging me.

In C i could use \" as I recall to put a double quote in a string. is this possible for VBA?

well, consider, you have an on open command on your starting form that locks you out of access's controls. so, you won't be able to manually remove that code anymore. so you need to have a button that would let you turn it off.

personally in that situation i prefer to make functions and place them in a module so that any sub can access them. but then i have a habbit of using a lot of subforms. Function delete_system(systemname As String) As Boolean On Error GoTo ErrorHandler ' ' ' delete_system = true...

i dont recognize that bar, are you using a subform inside of a form? if its an option you have turned on, its probably under the form's properties. thats where you can turn off the control boxes and record selectors anyway.

in vba, tools menu, references.