Search results

Did the example I attached in post #9 work as expected? The only other thing I see in the application is the data type of parameters in crosstab queries (or their sources) typically need to be specified. This isn't typically the case when the column headings are specified. It would hurt to...

I’m not sure if this helps but I found this page about ntDLL.dll.

I would use a single table and add a field that identifies the import date. Having multiple tables with the same structure is considered bad practice.

jgraham, welcome to this Access World forum. You might want to review past posts to make sure you aren't repeating an answer that was already posted by someone else. This is particularly true for a thread that is over 4 years old.

I would just place the filtering criteria in hidden text boxes on the form. The form could include a list box of the area/outlet combinations. Use the after update or on click of the list box to open the report with the where condition that uses the control values. As more areas or outlets are...

Imb, you are not able to post with links until after your 100th post in this site. The error message is not much help. There may be other limitations but you should be able to work around most of these.

Does the crosstab work if you change the first query to a make table?

You could attempt a reinstall of Office/Access.

I would have started this thread/concept with the smallest idea of creating a single multipurpose form with a little metadata to customize it at runtime. This would have been easier to conceptualize and digest. Most of us have done something like this (as evidenced from many posts) and would...

I don't have any issues with the file I zipped and attached. The SQL of the report's record source query is TRANSFORM Sum(Abs([IsActivity])) AS Expr1 SELECT tblActions.Action, tblWeeklyPlans.UserIDFK, tblWeeklyPlans.Loop, DateValue(DMin("StartDate","qfrmWeeklyReports")) AS Start FROM...

Does this only happen in the query or does it also happen in the immediate window (press Ctrl+G)? Does your code compile?

I think I have some of this working. I don't know why you used such a complex expression just to get the start date of the report. I changed the report's record source query as well as updating some control sources. The shaded text boxes need updating based on a continuance of the logic from the...

Always begin with two tables and get the join correct. Then add another table and get the join correct. Then add another table and get the join correct.

I'm not sure of the specification for your report. Also, there isn't significant data to validate results.

The least you could do is to mention the object names so people wouldn't have to dig through dozens of forms and reports. This might take a while to dig...

Imb "Do you mean the metadata-tables? Or the data-tables?" Aren't the data-tables dependent on the application? I would like to see the ERD of the metadata tables as well as some sample data.

I'm not sure if this resolves your issue but you have an extra "(" after the second SELECT. Try: SELECT ID, close, (SELECT sum(close) from VIX_DailyHist where ID BETWEEN b.ID and b.ID-4)/ iif(ID > 5, 5, ID) AS VIXSMA5 FROM VIX_DailyHist AS b;

Since all data entry should be done in a form, I would use the before update event with a little code with a dLookup() to identify an issue.

I wouldn't rely strictly on an autonumber field since records might have been deleted. If you tried something and "had troubles", you should be more specific, possibly with some sample data and SQL statement(s).

I have attempted to share the concepts with working examples and even spent a fair amount of time attempting to reverse engineer your database. I am worried any Zoom session would be going down a rabbit hole that I prefer not to. I am open to answering specific questions here where the thread...