Search results

I have an access database that takes orders and then when it is approved would take every item on the order and create a record in a shipment table based on availablity and then create any number of packages with and number of items in that package. In my product table I have a field that is how...

I'm not sure how to phrase my question but I'll give it my best shot. I have an order table with a details table. At some point a user must assign a vendor to each order detail in order to send out Purchase orders. I was thinking of using SQL insert statments to create the purchase order in...

Hello, I am currently working on a database that I did not create. It has 4000 records all with a field for a ole object where a picture is stored in the database. Since this is making the database 500mb I need to change it. How do I make this change. I would create a text field in the table...

Hi All, I have a long module that is exporting data from Access to an excel spread sheet. I currently have one long function. I would like to break it up to many functions. I currently pass the excel worksheet object into a second function from the first and work with the sheet then return...

Hello, I've used a bit of visual studio 2005 and on a form you can organize code by using #region and #end region I beileve. Can you do anything like that in access 2007?? Thanks Paul

Hello, I need a second bite at the apple here, I've got the following code that opens a webpage that is google and searches and works well but I still need some help messing with it. I would like the browser to open in the current window. Right now it opens in a new tab. Also if I could get the...

Hi, I was wondering if it was possible to pass values I have stored in my database and open up internet explorer or something similar and insert the value into the field on the web page then hit search... I've been a copy and paste fool and I hope there is a better way to do this. Thanks. Paul

Hello, I used this forum to help me create an access program that works great. I decided to change part of it and now it's doing something differently and I can't figure out how to go about fixing the new problem. I had a button that took a group of fields (all numbers) in a table and provided...

Hello, I was wondering where I should look in order to learn how to program a database in VB.NET. Is there a book I should get? I am currently just trying to make the same database I made in access and I'm running into problems I have no idea how to fix. I would feel awful posting a new thread...

I tried to figure out something and need some help. I forgot when I started on this database a field to sort Products on. So I added a field intSort to the table and was hoping to have the user press a button to order the list of Items on a subform by twos. That way when they add an Item they...

I'm hoping to have a button that fills in data in fields that are null. I was wondering the best way to do this. Currently I have a button that will go thru a set of records and fill in for all the records. I'm hoping to only have this work if a certain field is null and if there is somethere...

Hello all, I have a quesiton about using random numbers. I have a table for items in a database each with a price. I need to go thru and discount the price 10% to 15% randomly on each and put the new amount into a different field. I havn't the slightest idea how to do this. The closest I've...

I found code on the net for importing Excel to Access. The problem is it is code for the excel spreadsheet. I need it to be executed in access. So the following code in the spreadsheet of: Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _...

Hello, I use a database at work that I made. Unfortunatly, I did not add a field for numbering the items that a customer orders. When entering an order It is important to my customers to keep it in a certain order. how do I change it so it adds a numbering to all the past orders as well? I've...

Hello, I love this forum. Has helped me learn much. I have a button that populates an excel spreadsheet from data in two queries. It's working out great. However, Everyother time I try to use it I get a Method Cells of Object '_Global' Failed... I hit debug or end and then when I try the button...

I'm trying hard to learn VB but having a hard time with uncommented code I have found on the net. Here is the Problem: I need to take a report[invoice] and make it into an excel file to send to customers that prefer that format. I sure I can format the excel file in the way I want it but...

I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself...

Hi, As an example lets say I have customer names that I build a query for for a certain time. Lets say it has 50 names. I have another query with 10 names, nine of which are on the first query. How do I go about getting a dataset of the first list minus the overlapping names and ending up with...