Search:

Nope they tables are not hidden. I did check the properties. I can import to a local table, then run a query to update a linked table. I would prefer to not have any local tables stored on the...

The table that I want to put the data in is a linked table. I do not see that linked table in the "existing table" list. I can import into a regular table. As for conflicts, on export, I have removed...

I have my application with the forms/queryies/report/code in one app and the tables in another. Basically the tables are linked. In that client applcation, i am trying to import data from a csv file...

I have a query which shows product info and stuff. The user can specify what they want to search by, and select how they can order it

In my query, i am reading the values from the form and the...

Is there a function to determine HOW a form was open (acFormAdd, or acFormEdit)

Thanks

Thanks!. I was just trying to assign the value to early. I moved the code to the Form_Load() and everything works /forums/images/smilies/smile.gif

I have a form that records incoming shipments. This form is based on the table tbl_incomingshipments and has the PK of IncomingShipmentID. When the user click OK, the IncomingShipmentID is generated...

Thanks Hans, I just had to change the Me.ComboBox2.ListCount = 2 because I have the headers showing

OK, to expand this further. Lets say that I have a list of customers in a combo box and I have a button on the form which allows the user to add a new customer on a seperate form. Once that customer...

The bound column is Row 0 of the row source (which is the CONID). The control source is left blank. A selection from the first combo box will filter what is show in the second combo box. In this...

I have a combo box which is based on a query that pulls all the customers from a table. This combo box is bound by the ConID and has no control source. When a user select a value from a different...

I have a shipment form called "FRM_IncomingShipments" which has the record source coming from a table called "IncomingShipments". This form is used to enter new incoming shipments. I also have a form...

Actaully I got it nevermind /forums/images/smilies/smile.gif Dumb mistake. The problem was that I types in the master and child fields, but in one of the queries, I was not retrieving the Consultant...

Hi Mark,

Thanks for the reply, I have setup my report as you have stated, with two subreports and linking the reports together by consultant ID, but I am still having an issue. For each...

Edited by HansV - inserted <!t><!/t> and <!t><!/t> tags to preserve spacing - see <!help=19>Help 19<!/help>

This is the current situaition. I have one table which records invoices, and on each...

I am trying to add a value selected from a combo box (the whole row actaully) to a listbox, but I am unsure of how to add a value to a listbox. Any examples of how to add values to a listbox would be...

I do understand that, but there has got to be a way to get data in a report that does nto duplicate the product if part of it is on backorder and part of it is in the order.

Here is how the data...

Yes I do have that now. (that id was there at one point) but all the other values in the query are required /forums/images/smilies/sad.gif

Also, if the backorder and shipped amount are not the same, then that will not work either. I removed the PK from the query results to test what you have mentioned above

Unfortunaly, that did not work. There is one field in the recordset that is unique for each one, which is an autonumber

I have a report which displays all products in an invoice. Each product has an status attatched to it. (Eg. Shipped, backorder). Also, a product can have multiple entries. EG 3 Shipped, 3 Backorder....

Thanks for the help, Everything is going smooth now

Thanks for the input. Unfortunatly, I have still having problems writing to the spreadsheet. I have the spreadsheet open, but I cannot get anything written to it. My querys are pulling the right...

I have an item on my main navigatio which populates an excel sheet. For the life of me, I cannot get the excel sheet open. How can I open an excel sheet assuming I know the path?

Thanks

Is there a way to find out a persons computer name? Based on this, I would like to load a specific switchboard.

Thanks