Search results

This is great, it's definitely steered me in the proper direction. Here is what I've got it down to. I opened my accdb on my normal machine and on one of the XP machines that it isn't working on. I tossed in the MsgBox InStr(string, "delimiter") On the working box it give me 3447, so bingo...

You're right and should have included this but I overlooked it. Through my testing I have set it to If Instr(string, "delimiter") > 0 Then But I haven't had different results. Any message boxing, I tried that as well. Right before the parse I msgbox myself the string, "Gigantuam text box"...

Has anyone noticed any problems building there access packages in Vista and then deploying them on Windows XP? For the last 3 months I haven't had any problems until recently. I've tracked the issue down to a parsing issue. I have a bit of code that parses data it's set up akin to: If...

Thanks Adam, that's great. So if I wanted to make a search engine for my database and I wanted to be able to include the ability to use "-" as if it were NOT, I would basically have to parse the text box control accordingly and then build a sql statement off of the parsed line. Something like...

no, that's definitely not it. That would work as I originally said it does, with just "1" or "2" in my criteria. Not when it's "1 Or 2". My question deals specifically with the logic operators in the query criteria. And if I precede and end my criteria with "*" a problem arises when I enter "1"...

I was playing around today and found something that is odd to me. If I set my query criteria to "Like [Forms]![FrmName]![Text0]" it will work as long as it is simple. For example, I'm running the query against a table and my criteria is for the TableID column (1, 2, 3, etc). As long as I use...

PDAs, Blackberry's and all these other fancy shmancy devices are so popular now I'm thinking it's useful to get a bit intimate with what is needed to program for them. I've got a copy of Visual Studio 2008, and I'm somewhat fluent with VB. My beginning questions are: 1.) Where can I find a...

After installing a program update I was called back to the user's desk approximately 15 minutes later. They were complaining that the screen had just gone blank and the latest update must have broken it. I moved the mouse, screen saver turned off and the user was wowed with my amazing trouble...

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