Recent content by cbuono

Hi Shyam, you may want to take a look at how you are setting up your tables first. Typically an inventory system will contain the following: 1. Product Table - Product Number, description, weight, cube, etc. 2. Inventory Table - Product Number, Qty On Hand, etc. 3. Inventory Transactions -...

Hey guys, I need some major assistance with a listbox I've been fighting with for the last couple of hours. I have a query (that is selecting from table Pallet) that is populating a listbox. I've also used a Union query to add the text "ALL" at the top of the listbox. Now my issue...

Hey guys, I need some major assistance with a listbox I've been fighting with for the last couple of hours. I have a query (that is selecting from table Pallet) that is populating a listbox. I've also used a Union query to add the text "ALL" at the top of the listbox. Now my issue...

Actually this is a pretty simple task. There are .dat files under \\MSSQL\data that you can simply copy to the new server. Firstly on the new server create a new db that is the same size as the db on the old server. Once the db is created on the new server stop the SQL services. Also on...

I've used this kind of logic before and here's what I've done to make it work. 1. Have the list box populate a table. You may want to delete the data in that table first if you are going to run this report over and over again. 2. Once the values are in that table, edit your query so that the...

Actually what I do if I need to change the name of a label is instead of using a label, I'll use a control and make it uneditable in the form but in the vb section change the value of the control: Me![control name].Value = "Employee:" Where you place this will depend on when in the...

Well i was able to fix my problem. My insert statement was incorrect. Here's what i did: DoCmd.RunSQL "Insert into tbl_lookup_storer (storerkey) select '" & myctl.ItemData(varData) & "'", -1

Hi everybody. I am using a multiple record listbox to query a customer table and then show a new form based on those selected records in the list box. I am currently using the code below to create the where clause when the form opens. I would like it though instead of creating the where...

Thanks Gus. I'll play with it a bit and see I get the results that I want. Chris

Thanks Gus. I'll play with it a bit and see I get the results that I want. Chris

I am working with coding VB directly in a form but it seems that in multiple procedures I am performing many of the same functions. I immediate thought that I should create a module that carries out these procedures and then just call the function in the code of my form. Basically Im wondering...