Search results

It works now! It was an error 3134, which I looked up to be use of a reserved name. Which is when I remembered I have a field named table I didn't put in brackets. Fixed that, now she works like a charm. Thanks for all your help PBaldy!

The double quotes are within the entry in the table. I deleted them, but I'm still getting the error.

The SQL I'm getting now is: INSERT INTO [Master Asset Backup] ([Rpt Asset ID], [Report Name], [Report Description], [Category], [Customer Flag], [Owner], [Custodian], [Reportl], [Request Method], Frequency, [Detail or Summary Data], [Info], [Technical Authors], [Notes], [Report Delivered To]...

Wait, I now get Business Uses in the SQL (I did have it null, but I changed that and it appeared), however, I get a null for the value. Any reason that might be?

Thanks for the site about quotations; The SQLqry string is now working up to the "Report Description" field, or the last field in the string before the If Then sections and I get no errors when I run the code. One problem solved. The second problem, however, ugh. I replaced my statement for...

I have a form linked to a table which is used to edit the table. There is a button to save the table, but I also want to add the function of creating a new entry for a backup table to preserve the old record (with a version number that changes to know which versions are which). I keep hitting...

Ah, I got it. I was playing around with the invisible code, which essentially required me to get rid of the "width" variable, and in the end that solved my width dilemna. Working code looks like this for those wondering: Option Compare Database Private Sub Report_Open(Cancel As Integer)...

I was considering that, but the problem is I then have a report with awkward holes between the fields. The invisible ones still occupy the space. If you know how I might fix that, invisible would probably work better. Thanks!

Thanks, that syntax removes all errors and allows the report to run, however it's not making the textboxes disappear as I had hoped. It appeared to do so, but apparently that was something wrong with my filter, and with that fixed this code is barely effective. Option Compare Database...

I have a report with a form that supplies values for it to filter the fields in the report on, but also checkboxes to make the fields "disappear" if the user doesn't want them in the report. Problem is I can't get the mechanism to make them disappear work right. Here's the code I made...

So I have a report with a lot of fields that the user needs to be able to filter from a form full of combo boxes and text boxes. I've made code that I think should work but isn't. DoCmd.OpenReport "Custom Report", acViewReport, , whereString If Not IsNull(Me.txtID) Then whereCriteria =...

Well, CONSLING ANL was supposed to be CONSLTNG ANL, so there's that one, Then I plugged in and they didn't work one by one... Then I plugged in and they did work one by one and now together. In any case, thanks so much for your help!

Well, the good news is I can get the non-aggregate to run. The bad news is it returns no results, though it should. There are a total of six fields being returned and only these two criteria, which I know should return results. Any ideas? WHERE ((([Project Master Tbl].[Team Assigned...

Actually, the reverse: I want the end date to be today regardless, and the start date to be specified or default to not the first of the year, but today - 1 year (so today would return results from 8/8/2011 - 8/8/2012). I took your SQL and tried to twist it to apply to this: WHERE...

Hi, I'm trying to use SQL coding in the WHERE criteria to get a query to either A: evaluate a series of formulas from a table based on information from the date entered in a datebox OR B: evaluate a series of formulas from a table based on the year to date by default if the datebox is left...

Another question on a similar vein. Let's say I have one column, the first, which should always be =0in. How do I get the string to start on column 2?

Thanks G37Sam, that worked perfectly.

I have an Access Database with a multi-column list box, and I want to hide certain columns based on if certain checkboxes are checked or not. As it stands, I can use code like If ChkClient = 0 Then Me.lstDisplayReport.ColumnWidths = "0; 1 in; 0; 1in ; 1 in; 1in; 1 in" Else...