Search results

OK - I have created a working model. It is in a pretty raw format so you may want to take and take some time to make it look pretty. It is not as easy as just putting a function call in a query (at least in the process I came up with) maybe someone out there will take an improve upon it (which...

Since you can trap for a broken reference can you then switch the reference to a blank picture? Or is this a one shot deal you find the path and set it and do not know that it is broken prior to finishing the code? GumbyD

Well I lost all my formatting, hope you get the idea. GumbyD

ccocom - I looked at the screen shots and have started to design a test table the resembles your table. I have a couple more questions. Do all the question fields start with "IIComp"? Is the Number datatype on the question fields "integer" or "Long integer"? And finally I am guessing your...

Eric - Not quite sure what you want here? The Criteria statement you are asking for is when the data is equal to 7 or when the data is equal to 6 and 2. Since the data in your field will never be equal to both 6 and 2 at the same time then it will only return the values when the field is...

Very nice rich!

Wow - what a cool problem! I would like to write some code (which I think is the best way to handle this) and have started on some ideas, but I think it might be better if I had your database to work with so when I finish you can actually use it easily. Can you post you file or at least some...

In the report footer (or section footer if that is where you want the total) add a text box in the text box type: =sum([RunningTotal]) This assumes that the field name on the report is "RunningTotal" and that it is an integer datatype. Good luck GumbyD

You need to use outer joins and then add "or is null" to the criteria strings. Let me know if you need a bit more explaination. Good luck! GumbyD

When you say the "numbers are changing" Can you provide an example? I have a client with some issues related to AccessXP exports into excel, but they cannot change the data. Maybe there is some issues with the export? Are you moving data from a report or a query (if it is from a report if...

I tried it here on Access 2000 without an issue. You may have to add the to the parameters to the query by right clicking in the query design and selecting parameters. Make sure your datatype is date/time. The other thing to check is that the field you are updating is a date/time data type as...

Here you go.

Ok - here is a bit more information. I will attach a jpg with some images that might help and below is the how I changed your SQL for the query running the report. You wil still have to make a few changes to the report and may want to have your "Unit Price" and "Amount" fields in the detail...

Sam - Glad you got you want! I do have a screen shot of the structure I had in mind if you still want to see it. GumbyD

I took a look at your database. When I have had to deal with multiple currencies, I will create a new code table called Currency and put in the fields CurrencyID, CurrencyDesc, and CurrencySymbol. The data for this might be BP, British Pound, and the unicode symbol for the British Pound. Then...

simon - I must be dumb or something, but I am not sure how to attach an image to one off this posts. I press the IMG button but it gives me an http prompt??? You posted an image, what's the trick? GumbyD

Once you have the data in the temp table with all of the datatypes set to text, you will need to run a query the appends the record to the correct table. In the query window bring in the temp table (with the text fields) and double click or drag the fields you want into the grid. On the menu...

Toni - How are you getting the data? Are you using a dlookup or pulling the field directly from the underlying query? I have done similiar stuff to what you are doing and I used code. I created a function that ran after any updates to the data in the subform and then set the value to the...

I guess I pictured something more along the lines of having a trim table with a single key associated to trimdepartment and trimgroup tables with compound keys of TrimID & DeptID or TrimID and GroupID. It is hard to say if your design will have issues or not, a lot of that depends on how you...

Are there any message boxes or errors that the users are getting and what is the exact text of the message?