Search results

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

@PaulSpell - that sounds perfect. Do you know any sites that could show me how took do this? Thanks. @gemma - the easiest thing would be to ignore the errors, as that would seem not only the easiest task, but would give me a table of date and time when imports occurred. However, Paul's idea is...

I have about 10 tables or so that I export to XML. There is one main table that links them all. I believe that when it imports the XML file and finds primary index values already in the database, it creates this error. The error doesn't bother me, but it will to the end-users. I'm just trying...

@PaulSpell - Tried that, but didn't work in the sub form error... @pr2-eugin - I agree, the thing is I'm not sure how to modify the code to take out index keys and whatnot. If you have a suggestion I'd be more than willing try. Thanks for the help!

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 fixed it and I believe the solution was that one criteria in the query was off in terms of type. Thanks!

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

Thank you! Worked perfectly!

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 consider this bad design practice as well, but the client may not use MS Access in the future, so they want the values stored for now.

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

What ended up working was using making an alias for the three fields and using Val on them. Then adding those aliases together in the unbound field.

Yes. It's based off of two tables, and each calculation is purely of numbers.

The fields are from a query. I have set the Format Property to be Fixed and at 2 decimal points. But this wouldn't work, so I applied the Format function to the fields in the recordsource query for the form to get the to display properly. At the moment I tried this without success for the...

What can I do to convert these to integers?

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