Search results

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'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...

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'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?

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...

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

Hi, I've been trying to think of a way to do this (just conceptually). I have a rather large table of price quotes from suppliers with columns: line_number (primary key) | quote_id_number | item_code | quantity i'm using an msdn sql server and access 2002. the line_numbers are just an...

Hi, this is my first post here, and like most folks, i've got a problem. I'm trying to develop a database of components for my company; all components are identified by a 10 digit primary key and have two atributes. I used some VBA code to handle insertion, let the user pick from some drop...