Search results

Hey RG, Thanks for your attention to this thread. I checked my SQL for my recordset and I actually have two order bys, one for item category and one for item name. SELECT tblPrintBarcodes.lItemID, tblPrintBarcodes.Quantity, tblCatagoryMain.sCatagory, tblItemMain.sItemShort, tblPrintBarcodes.ID...

-1 and 0 I believe OnClick If Yes/NoBox = 0 Then Yes/NoBox = -1 Else Yes/NoBox = 0 End If This should make a toggle switch.

Hello, I am running Access 07 and I am having a problem with my printing that is just baffling me. I have a form that is used to view which items have been added to a que to receive a barcode. Here, quantities can be changed regarding how many of each item are without barcodes and items can...

Hold shift while opening ?

I could be wrong but let me give you this and see if it works. This would go either in the OnClick event for a button or on the after update event for a text control if you just want them to type in the number or scan the barcode and have it hit enter. Dim rs as DAO.Recordset Dim Sqry As String...

I was concerned that I would have hard times with Vista Ultimate, but I popped it on anyway. I only have 2 gigs of ram, that was my concern. Vista gave me a huge performance boost in Age of Conan and Mass Effect. I was very impressed. AoC usually chopped at about 15 - 20 FPS, it's not easily...

Hello all, It's been a while since I've posted but I've been digging around trying to find as much information as I possible can regarding Recordsets. I have a few questions as the resources I have give me to dots but I haven't drawn the lines as clearly as I'd like. From my understanding, a...

After a long time banging my head off the keyboard the answer diffused into my skull! I am using Wait = Timer While Timer < Wait + 2 DoEvents Wend Do Until Browser.Busy = False DoEvents Loop and it is working very well. I have 6 different text boxes on my form and the activex browser...

Hello, I'm experimenting with a web browser on my form and I had thought that the following code: Do While Me.Browser.Busy DoEvents Loop Would basically make the code wait until the browser had finished loading to continue. Unfortunately it isn't true. Right now I'm running with a manual...

I've been playing with an Active X Web Browser and I haven't been able to find a good library for ActiveX Controls so I've been pretty limitted with what I can do. So far I've picked up the Navigate and the innertext bits from here, but I'm curious if anyone has a good place to go to find code...

Hello, I am packaging an inventory program for use on multiple computers across a network. I have already split my database and before I package I am curious if there is a module or code, or if Access will do this automatically, that handles finding the backend if it is moved. I don't need...

Afternoon, I've got a search form that brings its results up in a list box located on the form. I have 3 image controls on the form and I would like the image controls to Display the images linked to the top 3 results in the list box. I've gotten an image control to display the image of the...

Yup, I can PM or post the DB if you want to take a peek.

This is really driving me nuts. Effectively I want to reverse the column and rows, relative to a standard access table. Instead of the report being a table all fancied up where records run horizontally I want them to run vertically. So instead of: ItemID ItemName ItemDesc 1...

This worked well for Print Preview mode, but is there anyway to carry this over the Report View? It's odd to me that Access would do this, when I view in print preview the columns are there, though when I switch to report view it goes back to a single column. Bah!

Thanks gemmy you always know exactly what I'm looking for.

So I have a question about the layout of reports. I understand that a typical report runs horizontally, 1 row for each record. I suppose as such: 1111111111111111111111111111111 2222222222222222222222222222222 3333333333333333333333333333333 4444444444444444444444444444444...

This is really good. I can definately get this to work well. Thank you very much

Hello, Here's the dilemma: On a form designated for data entry, FrmDataEntry, I would like the user to be able to select an image from a folder within the DBs directory. I've been looking at the mvps write up on it, I snagged that link from a post here I found through searching, but I really...

Is access hosted on a server, or network computer? Is your computer set up to Sync with that computer ? Goto your IT department and pull the IT guy away from quake for minute and beat the answer out of him =)