Search results

I plan to use Sharepoint, but I am unsure as to how appending will work in certain situations. Example: I have two identical databases sent out to two users. They both fill out different information into the same tables. The two users then sync the data to Sharepoint. If it helps, each user has...

Thanks for that. I guess I was hoping that if I had something like 10 controls, 5 of which were textboxes, I could somehow define (for example) 3 of those texboxes in which to go through and apply whatever values as wanted.

Sorry about that, MS Access was giving me some crazy errors and I thought that somehow it was my code. However, the knowledge on the array is much appreciated! Is there a way to specify a collection of names though?

Thank you for the clarification as I do mean collection. So in a For Each case statement, you would not need to declare the virtual array? What if I had 5 fields and only wanted to go through 3 of them? Other than that, is my code valid?

I'm trying to understand how I can make an Array and For Each statement work together. I normally don't use either, but it would be good so I could write less code where plausible. Here is the example I have: Dim Named As Variant Dim Ctl As Control Named = Array(Me.Namee, Me.ID, Me.Title) For...

Just clarifying as I tried the On Format event for my field header and making them invisible didn't work. No errors, but not working. All fields are in a vertical format. Tried seeing if maybe this was only meant for Print View, but it gives me errors when switching to that view and all the...

This raises a good point I was wondering. If the fields were organizes vertically, and a few in the middle were invisible, then the gap would disappear?

Gemma, very interesting. I can't use the first as they input the information on the form, but this query is only used on the report. However, I am very intrigued by your second method. How would this work with more than one custom Bit Size?

Not a strange question at all. Certain fields may not always contain a value and I would prefer them to be gone if that is the case.

Is there a simple way, or special event, that can be used to turn off the visibility of fields when they are in the detail or in a created header for a field? I tried using the report's Load event, but this kept giving me errors. Are any of the events in the detail able to allow this? Thanks.

Thanks for the reply. Your definitely right about the multiple queries for the Bit Size. I just used a group and sort on the Bit Size to get them all listed as wanted. There had been a problem with totals since it would use all and not for each Bit Size, but I just had to pass through the Bit...

Thanks for the reply Pat. I may have not explained what I was trying to achieve as well as I liked. Moreorless, there is a listbox for the Bit Size field on a form. However, the user is not limited to the listbox as they can input their own Bit Size if it is not on the list. On the report, when...

I have a query that has three fields: 1) Days 2) Bit Size 3) Feet. The Days field has a date range specified in the Criteria that comes from two unbound fields on a form. I have a second query based on the first: Two fields are Days with the Total as Min and Max. Three fields are Feet with the...

Sorry for the late reply! Here is a small version of the database. Essentially, use "0002" and "NMG2" for the User ID and Password. Then when you click through and get to the Dates form, you can use 4/12/2013 and 9/17/2013 (preferred) for the dates. ALSO, DO NOT COMPACT AND REPAIR, it actually...

I have been working on a chart the last few days trying everything I can to get it to work, but it just doesn't seem to do what I want it to. I have a query that calculates 4 fields according to what day (5th field) is chosen. At the very least I want a graph that shows the 4 fields as columns...

Thanks, Bob. I had read this before, but it's good to know it's true by a pro.

Thanks for the reply. I actually figured out a workaround. I used the subreport's Timer event to use my code with IsNull. The timer interval is set at 2. I tried this on the main report as well (timer interval at 4), but it didn't work (no error given, just ignored). There are a lot of...

IsNull works in the subreport, but still the same error if on the main. Likely an event issue.

Actually may have solved this. Len doesn't seem to be working but IsNull will.

I have some code in the main report's On Load event that begins with: If Not Len(Reports![rptDRMCSCCD]![rsubPersonnel].Report.Namee1) > 0 Then Reports![rptDRMCSCCD]![rsubPersonnel].Report.Namee1.Visible = False Reports![rptDRMCSCCD]![rsubPersonnel].Report.ID1.Visible = False...