Search results

Hello Again everyone I was wondering.. if it is possible. I know (its sad but its not at my request) to do a lookup table in a datasheet for a webdatabse, with a filter. Not at my choice, but tried to explain to them not to use a lookup table :confused::confused: You can see the attached...

I have my web database as alternating rows. See img. Is there a specific command or possibly something I am missing in my datasheet that I can say hey, cut off at the end of the data or where the column ends. See the img below . Meaning that I dont want the rows extending past the table...

I've been using the subroutine for my database and now need to move it to a web database. I use the combo box for one selection, to fill in my other fields Ive been using the Me.TXTHULL_NO.Value = Me.CBO_CONT.Column(1) line to input for my other fields. How can I use something similar for a...

I am looking to LIST the names of the items for my combo box. figured out my problem last week why my fields weren't attaching to my txtboxes its cascading combo boxes. I have about 5 fields I looked for this on the web and found baldys code Me.CBO_CONT.RowSource = Me.listObjects was/is my...

Hello Again. I am having an issue with my combo box. The code I am using is not populating my other boxes. attached is my database. and form. This is the code I am using for the combo box. It is not pulling in the data from the query. Private Sub Combo69_Change() Me.txtMATL_.Value =...

Going to ask a dumb question on here. Brain fried for a day. Trying to maintain Data for a datasheet We are trying to maintain the data throughout the datasheet table. Meaning that Field 1 Field 2 Field 3 Field 4 1111 Contract Apples Carrots 1111 Contract...

I have a nice laid out query, trying to keep the masking fields. aka !000\V/00"Ph"/00"Hz";;_ sample, 480V/60Ph/03Hz when I use my query to concatenate the fields, it comes out as 4806003 how is it possible to keep the fields with the masked inputted data? with the !000\V/00"Ph"/00"Hz";;_ sql...

I am doing a lookup wizard for a table. I was wondering if it is possible, I know its possible in a form but again trying in a table. I have a parts table in the parts table is a field called electrical_data a number will be entered into the table aka 1 I have a electrical table...

Having an issue for ensuring all tables and forms are web compatible. we are getting this error for web checking. I have attached the zip of the db ... I know I can use a generic navigation form from access 2010 I like this switchboard very much. it works very nicely. it is only...

First I have to extend my appreciation for those that have been working with me the past couple of weeks. I am looking to transfer my tables from my blank database tables to a web database for access 2010. In the process I am creating some new tables for the transition. How or where the heck...

I am in need of some expertise.. I have the code for the report .. having difficulty pushing it into a query If possible can someone help me correct my code so it will then push it into the qryallemployees? Option Compare Database Option Explicit Private Sub cmdOpenReport_Click() On Error...

Hello all Not sure if this would be a query or table or whatnot. This is the breakdown. I have a PO ORDER no, with a auto number starting at 4000. That specific customer is ordering the following items item 1: 5eggs item 2: 6eggs I have the items set as auto number, and I need the po as...

I have a relationship from one table to another. If one item is entered into one field, I would like it to auto-populate it into another field. But there are several more fields I would like to be autopopulated. EX Table_1 item no, hull no, description Table_2 item no, hull no, description...