Search results

I put the code in properties "on load" of the form. but I get an error message can't find the field "select date" referred to in your expression.

where do I put this code?

When placing my Calender control on my form, I can't seem to have the default date show when opening the form. I thought this did it automatically. But how can I get it back?

I tried that and my listbox is not refreshing. But when I run the query from a button it refreshes in the dynaset view

Do I put that in the "Event Procedure" on the After Update?

Hi all, I have a listbox that gets it's data from a before date and end date text boxs. Then two combo boxes to specify more criteria. The problem is when I put in my before and after dates, I want the list box to show my data that correspondes to the dates. And when I select from my Combo...

Increment button I would like to change the value of particular records in my table by + or - 1.

Hi all, I would like to have a button on my form that adjusts a number value of a record in my table by increments of + or - 1. Anyone know how to acomplish this? Thanks, Stevegr

Hi all, I have a Table that hold records that I want to update with a calculation. I created an update query that changes these records to the value I want. (performing a calculation *1.5) The problem is that every time I run the Query it performs another calculation to all the records not...

I dont want to trigger the action though. I want it to do it without intervention. Maybe a script of some sort? Does anyone know how to write a script to alter record before going into a table coming from another source?

Another software program is looking for the values in a table.

Hi all, I have a Access Database that has a table with a field named "Values". I would like to preform a calculation on all these records from within a query. (Adjusting them by a certain percentage) Then store them in another Table automatically. I don't want to have to go thru the steps of a...

Hi all, Does anyone know if there is a way to transfer data from an AS/400 Mainframe to a Access table? I currently transfer it into an Excel spreadsheet and then link to that. Which is OK, but I am wondering if I can cut out the middleman. Thanks, Stevegr :) :)

But what if I don't want to pull from a table. I have two tables that I combine to get all data from using a Union query. I tried using: Select* From Qry_Combine_Tables Where Fieldname=forms!Formname!FrameID: But it doesn't work. Can someone give me a hint at what I am doing wrong? Thanks...

I can't seem to understand how you set the properties for an Option button group. I have fields in my tables that are either a "1" or "2", and I would like to query all records with 1s or 2s threw an option boxs on my main form. Thus selecting option button 1 or option button 2 to query records...

But what if I want the option to enter specific criteria or * for all records? Can I do that ? Thanks, Steve

How dow I show all records using the * instead of specifying criteria for certain records? I am in the design mode in my query and not sure how to proceed. Thanks, Steve

Never mind, I got it

I used a SQL statement "SELECT *" to query all fields from both tables, but the records under field headings got mixed up. This is probably due to the field headings are in a different order in the tables. But my table is layed out that way because I importing data from an excel spreadsheets...

Im sorry, I feel so stupid. What is a QBE grid?