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...

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...

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.

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...

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...

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...

Issue: I've been using Allen Browne's code, and it has been working well until now. When the code runs it produces no Access errors and seems like it works fine; but on closer inspection one of my subforms is not having its values copied over... Insight: I have a main form with tabs that have...

I have a query that performs some calculations, these calculations feed into another query and produce a final value. If there are no null values everything works perfectly. But when there are null values, I get errors. What I have tried: 1) I tried to implement the Nz function for each field...

I have two subforms on a main form. I was wondering if there was a way to capture the tab key so that when they reach the last field on the first subform it will tab them into the first field of the second subform? What I have so far is to turn on the KeyPreview in the first subform's load...

I have a button that checks two fields in a table to see if a user has used a date in the past. The fields are UserID and Days. The code is: DCount("[UserID]", "tblGenSum", "[UserID]= '" & Me.UserID & "' And [Days]= #" & Me.txtNewDate & "#") > 0 The purpose is so that the user never repeats...

I have been problems with error 31550, and have a previous post about it. But one of the ideas was to create a temp table. I was thinking I could have a temp table created, store the data there, have it checked against the current data, then only important what data is not present in the...

I have the following code for importing and appending table data: Application.ImportXML _ DataSource:="c:\TEST.xml", _ ImportOptions:=acAppendData The code works perfectly. It gives the error that I am trying to create duplicate index fields, and then create an "ImportErrors" table; which...

I have a combobox on my main form and simple code for its AfterUpdate event: Me![Days].SetFocus DoCmd.FindRecord Me!cboPDates, acEntire Row Source: Field - Expr1: Days Criteria - Is Not Null Field - Expr2: User Criteria - [Forms]![frmUserID]![UserID] This used to work flawlessly. It...

I have a field and a button that allows the use to put in a new date, click the button, and create a new record with that new date. When the button is clicked the following DCount VBA is implemented: If DCount("[UserID]", "tblGenSum", "[UserID]= '" & Me.UserID & "' And [Days]= #" &...

I have two, nearly identical, forms. One is for metric calculations and the other for imperial. The metric works perfectly, the imperial does not... The forms consist of 4 subforms. All the subforms on the metric will show without issue. The subforms will also show on the imperial, but the...

Now that I understand OpenArgs, I am wondering what would be a use for it that no other method could handle? I have seen ways to get around its restrictions (more than one value, etc.), so that's nice, but I still find other methods easier in situations (or just as easy) to use. I guess, put...

I have two fields on a form, UserID and Password. A person types in the UserID and Password and clicks a button to go to the next form. The button performs a DLookup function to check whether or not the UserID and Password exist in tblUserID. The fields for both of these are text in the table...

I have a form that contains 3 subforms. Each subform consists of calculated (unbound) fields that are from calculated query recordsources. My goal is to add the values produced by these unbound subform fields to one table. I am unsure how to go about this. I at first thought that Allen...

I have three fields that calculate different numbers from a query, then a fourth [unbound] field that adds them all together. What ends up happening is the unbound field puts them all together instead of adding them together. Here is an example: Field1 = 1 Field2 = 2 Field3 = 3 Field4 = 123...

I have a complicated form that has about 3 subforms on it. Each subform is based off a calculated query, which in itself consists of several other queries. I need to have those calculated values be committed to an existing table. I understand that storing calculated fields is not practical, but...