Search results

Hello, I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc. I want to know if I'm going about this the right way, and if so, what's the next step. I'm splitting the database, making an ACCDE for users: 1. I inserted code to disable the bypass key. 2. I...

Okay, I'm sure I'm reaching here, but I'm exporting a query to Excel, and I want to be able to conditionally format certain rows of the export using Access VBA. Is this possible?

I don't allow users in the tables or queries either. The query is being exported to Excel.

Hello, Is there a way to hide a field in a union query? I need to keep the field in the SQL statement because I need to order by it. The field is "Rank," but I don't want it showing up. Thanks! Jeff

Okay, I will try these. Thanks both for your help!

I'm having trouble inserting a screenshot. The attachment is too large. Here is what it looks like: Field Size: Double Format: Currency Decimal Places: 2Data being imported: COID Company Name Net Excess Minutes '$$ Charge' 12345 Company ABC 1000 134.75I...

I actually do have a template table. My import goes to this template first, but it is not coming in to the template properly. I checked all the import specs, but can't find anything wrong. Here is my code: Dim strMsg As String Dim strSQL As String Dim strAppend As String Dim strDelete As...

Thanks both for getting back to me so quickly. @TJPoorman: Did you mean change the Field Size to Double? I tried that, but it didn't work. @CJ_London: I sorted the file so a number with a decimal was on top. That worked, but I was hoping there was a better way to avoid it. I've looked at...

Hello, I'm trying to import a CSV. When I open the CSV, some of the values have decimal places (e.g. the dollar charge is $342.25). When the file is imported to a table, it shows up as $342.00. I import this file every month, and never have a problem. For some reason this month, the file is...

I'm not good with recordsets, how would I do this?

Okay, I know I've done this before, but I can't remember how. I have a combobox with a row source of existing values of that field. One of those options is "None," which I want to show up as the last option. So the existing values are: "Adam" "None" "Zak" But I want: "Adam" "Zak" "None" My...

Each form is used to populate dates on the separate subreports. The subreports can also be opened on their own, and I didn't know another way to do it. So a subreport might have a date field with a control source of "=Forms!frmYBFinancialUpdateFilter!txtAsOfDate" I'm sure there's a better way...

Hello, I am trying to open a report (with subreports) from a form. When the report opens, I want the form to hide, which most of the time does. Sometimes, though, it won't hide when the report opens. So, I even created an error handler, and moved that part of the code to SubExit section, but...

Lagbolt, I see what you're saying, but it's the pop-up I want to be invisible, not the report that I just opened.

Yes, I tried that, but it doesn't work either.

Okay, this one is driving me crazy. I'm trying to open a report with pop-up form. When the report opens, I want the form to stay loaded, but hidden. I'm using Me.Visible = False, but it's not working. Here is my code: On Error GoTo SubError 'Open Report DoCmd.OpenReport...

Okay, I attached a stripped down version. As you can see, in both queries, qryCPUMonthlyByRegion and qryCPUPendingCharges, I cannot see a line for North America for $0 on 8/31/13. It doesn't matter which query that line displays, so either one is good. Thanks!

Reading through my posts, I'm realizing I did a poor job explaining. Let me see if I can reword it. Let's say I have the following entries: Company Region Billing Effective Date Monthly Charge ABC Co. N. America 07/31/2013 $1,000 XYZ Co...

I think because there are no entries for any North American customers with the Billing Effective Date of 8/31/13 in the original table (on which qryCPUMonthlyByRegion is based). So it's not pulling in anything for that region for 8/31, if that makes sense. The reason I had the Group By is...

Thank you both for your responses, but I'm still having trouble making it work. Here is my SQL statement: SELECT tblCPURegionPlans.[Region Plan], qryCPUMonthlyByRegion.[Billing Effective Date], nz(qryCPUMonthlyByRegion.[Monthly Charge],0)*1 AS [Month Charge] FROM tblCPURegionPlans LEFT OUTER...