Search results

When opening forms from the main window, they work just fine. But, when I try to open them thru the switchboard, they stall and the progam seems to freeze. How do I overcome this? What is happening? This has actually happened on more than one database on different computers and I've never...

Perhaps I was unclear; or, I just don't understand the reply. Let me try again....the incoming data will fill a column. In order for the subsequent queries to work, I'll need at least one of each values (1-6) that would have a number count associated with it (ex: 1-25, 2-10, 3-115, etc)...

I've built this database that works just dandy if I have data in all categories. If I pull data (from huge warehouse database) and append to my main table, is there a way to make sure there's a value in all fields? Should I do something on the query? Or, make an adjustment to the table set-up?

There are 4 macros that each run 2-5 queries each that with a parameter gather data for a month, make a table, preform calulations, and then open a report for printing. Again, the macros work from the main window. But, is that just too much to run from a switchboard? I'd like to make it as...

When I run the macros from the main screen, they run just fine. But, when I try to run them thru the switchboard, the program either freezes or slows down so much the icons take about 3-5 minutes to re-populate the screen. I'm wondering about modules; but have no experience with them. Is...

Thanks for the suggestion, Wayne. I don't think I've made myself clear, though;my fault...sorry. The data is gathered from an outside source that already has a date field. Now, I don't want to monkey with the data, just gather it in different ways for a report. The report I'm trying to model...

Oh, Thank you! I've been trying to get the information posted earlier to work and am not successful. There's mention of needing a date stamp for each record. Would a date field work? If so, how. I've been trying all sorts of things and I think my brain is starting to warp.

accumilated info with date criteria Is anyone there this time of day? I could really use some help with this at the moment.

date help Thanks for the help, I'll try this out tonight and where it takes me.

Am looking for a formula to calculate a running total on a number field using dates as the criteria. For example: I type in 10/31/03 and get that days total; also get the week to date, month to date and year to date total numbers. Is this even possible? Would I have to nest queries for each...