Recent content by andyrew30

Hi, I am at work, and I have acquired a database that prints labels. They now want the database to be coded so that after certain labels are printed the database will print a blank label. I have the code figured out as a Do While statement in order to print the blank label. The problem I am...

Perfect! Thanks

Hi everyone, I have a database that uses a switchboard and it has 4 options, the option to start a new entry, edit the entry, run report, and exit. The database then saves new entries into a table. The database works perfectly with the exception of the edit entry button. The edit entry...

I'm not sure what I did, but it started working correctly...I think I was resetting the value back to blank to early. Thanks for the help!

The textbox is unbound. I set the textbox equal to a variable "stPartNum", then in the middle of the code I use "DoCmd.OpenReport "RptLabels", acViewPreview, , , acWindowNormal, stPartNum" to open the report, and at the end of the code I set "stPartNum" back to ""(blank). But when i use that...

Hi Guys, I have a quick question that I've spent a decent amount of time looking through google and other forums and still can't quite figure it out. Essentially I have a form that has a textbox in it. I enter text into the text box by scanning a bar code. I then use openreport.cmd to pass...

Hi, I am not sure if anyone will know much about this. But I've googled quite a few things and come up with nothing of much help. I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an...

I ran into what I believe will be the last major error in this program and it's still along the lines of the scannertxt. Essentially i am attaching a dlookup function to pull the value of one of the columns in a table when a parameter is entered. This is currently what my dlookup code looks...

Life saver man!!! Thanks

So I set it up to pull from the form as you had suggested. But I can't figure out the code to get the reports to open based on a saved variable from the form. I am currently trying this: Where ScannerTxt is my input box. Private Sub Command5_Click() Dim stPartNum As String...

ok. I will try that. I think that may work. Thanks

Hi All So the question I have is that I am trying to copy the parameter value that is entered to a variable so that it can be used to run other queries without typing it in over and over. Once my form is finished it will run 4 queries, and the current setup is that I would have to retype the...

The problem I am having is with an intranet page. I am trying to access a text box that is located within the body frame, but when I reference the html page using: ie.getElementsByName("file_id").innerText = "Our text" ie.Document.getElementById("file_id").Value = "1457899" Or something of...

It's an intranet site at work that searches from a database. So the url never changes.

Thanks for the quick reply Mile-O!! That helped a ton. The next part is a little more advanced and I am not quite sure how to do it. I now know how to enter the data into the search box using: ie.Document.getElementById("file_id").Value = "1457899" But the problem I am facing is that the...