Search results

Scottsman, did you ever get this working? I'd like to add an additional field to a chart I have. I've added the additional column to the query behind the chart, but haven't figured out how to add that field to the line graph. You can right click the chart and edit. A datasheet show with the...

I wonder if you could recursively traverse your relationships and import the parents before the children. Just don't ask me for the code.

Go into Database Tools>Relationships. Right click a join line Edit Relationships. uncheck Enforce RI

You can turn off ref integrity, do the import then turn back on. However, you may need to fix some records which don't meet the requirements for RI before you can turn it back on. The only danger would be if someone else was accessing the data also and deleted a parent record (or something which...

Are the unique fields in a different table or the same table as the fixed fields? How different are the unique fields for the different templates? So the 15 fields are the same for all 20 templates? Providing your table design might help me give better advice. You should try the form/subform and...

in an empty column in the query do something like ColName: IIF(isnull([DateField]), [FieldWhenDateIsBlank], [DateField]) I'm having a hard time understanding you explanation, but hopefully this will get you on the right path.

welcome to the forum

If you have 20 templates and each has at most 6 unique fields, how are you getting to 200 hidden fields? If most are the same with only a few unique to a template, I'd think hiding the fields would be easier to maintain than to have 20 forms that are mostly alike. I suppose you could have one...

Sorry, I thought you were saying that the combobox wasn't sorted. What is the RecordSource for the subform? This is where you'll need to do the sort

Putting an empty string ("") in the second argument looks suspicious to me. This is saying ton not give it a name. It's an optional argument, but if you don't want to specify it leave out the "". The other thing to try is to stop the code in debug and look at MyPath & MyFilename to make sure...

go into design view for your combobox. Edit the query that is the row source for the combobox, and sort based on the field you want sorted by.

have each button build the query you want to see in the subform, then put the query into the record source and refresh the subform.

>>1 consignment note can contain multiple cylinders you'd set this up like ConsignmentNoteTbl id other fields CylinderTbl id ConsignmentNoteID (FK) other fields The ConsignmentNoteID field is related to...

what's not working. list your sql. You should be able to put a field in your query fieldname: ([asum]*1.2)+([bsum]*-1)+([csum]*0.25)... Or you could build the query dynamically in VBA using a loop. I don't know of any function that will sum across columns. if the multiplyby values are in a...

I can't tell if you're going to have data for both countries in a single database, or you're only going to have data for one country and it's data is in a table corresponding to that countries properties. If you're going to have data from both countries in the db, could you simply add a field...

Yes, you could change the links dynamically within the front end.

What data is your report supposed to show, main form or subform or both? If both or main form, then you need to set your join line between the tables on you relationship to be all records from the parent table and only matching records in the child table. If subform data, why would you want...

you have a vertical bar in front of your if (=|If )

If you are using tabs, close all your other tabs to see if that helps.

I played with or'ing null values in the immediate window and it looks like null is regressive. So if I do true OR null, I get true. 1 or null = 1. null or null or null or 5 = 5 Your OR statement will only return true if every one of your controls returns a null value.