Search results for query: *

I use a make-table query, linked to a live Fox Pro table, to create a static table. The problem is a date/time field converts to Text, and I would prefer it remain a date field. I am trying to run a query that compares two dates, but even when the fields are both set up as text, it appears the...

I use a make-table query, linked to a live Fox Pro table, to create a static table. The problem is a date/time field converts to Text, and I would prefer it remain a date field. I am trying to run a query that compares two dates, but even when the fields are both set up as text, it appears the...

Can anyone recommend a good Access training class for a savvy Access user w/ no programming skills? The class should teach programming & VBA basics to allow the individual to develop more custom applications. Thanks!

The parameters are actually set up in a query, and not the data source (table) or the report itself. If you know of a way to make it flow, that would be wonderful. This "blank" issue appears to occur after any change to the report header - not just parameter issues. I am completely...

If the query is the data source for the form, you just have to enter a bound box that says the exact same phrase as used in the parameter query. The info will flow without the user having to enter it twice. For instance, on some of mine, I put this in a bound text box in the header...

I have a report that is based of a table, rather than a query, for performance's sake. A macro kicks off all the queries necessary to build the table & open the report. The first two queries in the macro are parameter queries. Since the data source for the report is the table, and not these...

I have been working on a very complex report for days. I was just putting a few extra fields in the report header. As soon as I did this, the report began opening up as blank. When I closed out and tried to open from the report tabs, nothing happens when I double-click. If I totally exit...