Search results

I have a split form to update a table and on the form I have a clear button to clear the table for the next entries. I want the split form to requery the table after the delete query runs in the data portion of the split form I get the #Deleted in all the data fields. I know that the table is...

I have a form to input to a table with only three columns of data and when I run this form it opens in full screen. I tried to use the docmd.movesize to no avail. Then I set the popup property to yes with the docmd. movesize and I get an "Invalid outside procedure" noticeon loading which, when...

I have I am doing a report on a query with two dates based on table and a different query, plus some other fields. The table is comprised of information created from a form of which one of the fields is a Delivery date and formated as a short dates from the form. The query is based on a table...

This has probably been answered before but I don't know the key words to get a search. I have a form textbox that updates a table. I would like to have something like a rowsource without the combobox to make sure a number doesn't get to the table unless it is in a field found in a specific...

I get a "Variable not defined" at the red text of this function. Can someone point out the reason for me. I copied pasted this out of a different process where it worked correctly. Function PurgeSelectedOrderNumber() On Error GoTo mcrPugertblSelectedOrderNumber_Err SetWarnings = False...

I have a form that builds a temporary table with two fields. One is a date field entered on opening the second field is numeric. The date will remain the same until the process is finished. My problem is unless I put the date in again it will not update the date field for the next numeric entry...

I haven't been in Access for almost a year and being 70 my memory is not like a steel trap anymore so I can't get a handle on this project. If you could help me get started again I would be eternally grateful. I have a simple query that picks off order line items that have been billed. In the...

I am trying to append selected records from one table to another but my code doesn't do the trick. The table structures are identical. These are inventory items and I am trying to select certain Vcodes and have those records append to the second table. The rowsource is the Vcode from the first...

I want to be able to open a query or table ( I haven't decided which yet) from a multiselect listbox list using part number vendor three letter codes. As many of our items are purchased through a wholesaler the buyer must analyse several vendors products to generate a purchase order...

I have two forms both using the field Part as an ID. The analysis form has purchasing criteria and the other has all the background detail that the analysis form uses to populate it's fields. I want to be able to double click the Part in the analysis form and open a tabbed form with the detail...

I am using this to populate a spreadsheet but my data is way to large (10,000+ lines in 31 columns) to use this effectively. Help indicates transfering data in an array is the best way to go but I can't figure out from their example how set this data from a query into an array. Below is my code...

I can't seem to get this to work. I am trying to force ListMargin to 0 if Cost or Sell is 0. This is the statement I am trying to use. It gives me an Undefined functin 'IFF' in expression error.It's quite possible I am misinterpeting MS Help. I would apprecate someone setting me right. I get my...

Is there a way to run a saved import of tables through VBA? Or must I do a separate import for each table?

I have search all over including this forum but there doesn't seem to be an answer to the problem. When I try to go to Microsoft support I can't get any help unless I am a volume or contract user. I am trying to link 4 tables to a data base from another access data base that gets update daily...

I would like to populate a field in a form based on a table and have it's value come from a query thats not part of the forms record set. Is that possible? To clarify I have a query that provides the average unit sales. I have a table of inventory items the buyer looks at to determine a...

I want to make a function similar to this one provided to me from PBaldy and I don't know how to make it work for me. Originally when working with Paul I had queries built for each month of the year and this would run what ever query that matched the month the process was occuring in. I am...

I have tried to do this with no success so I am wondering if it is even possible. Can you update a field in a query from a textbox on a form?

I have some calculated fields in a make table query and one field allows me to set the decimal places and the other doesn't. I have both fields set to General Number format. This has come up in different queries and I don't understand the dynamics. Thanks for looking. This one does SP...

I am confused as to how to get results I need from a select query. I have three queries Inventory, Quantity on hand and Quantity on order query. What I am trying to get is the inventory part number and description along the the amount in inventory and the amount on order from a vendor. When I...

I am building a database to give our buyer a tool to find under and over inventoried items and develop a recommended buy report by inventory item, vendor and warehouse location. I am working developing this information from a nightly download from our main server into Access. With this...