Search results

Gear, you need to add a unique identifier to the table. Then you can choose to keep either the min or max value of this new field (no difference either way) to give you the remaining single record.

I agree that making the query do the work is probably best practice. I was merely suggesting that, sloppy as it may be, this solution would also work.

It doesn't return a string if you define what it is first.. Dim sdate as Date Dim edate as Date It works ok on my test db.

I may have misunderstood how you are doing this. Having looked closer, you can do it your way which would work. The only thing you are missing is to turn the filter on. me.filteron = true add this after adding your filter and you're away. Don't forgot also the define your variables at the...

I also think that you are missing the word "and", and using then if. I assume that each if statement must meet all listed criteria. eg. The below....... if {ITCSNBILL.UPI} = "10386" then if {ITCSNBILL.SERVICE_CD} = "H0036" then if {ITCSNBILL.SERVICE_DT} > date(2005, 10, 06) then...

This should be in the query criteria under your date Between [Start Date] And [End Date] Hope this helps

Hi, Am I right in thinking that you are calling this report from a form? Filtering on a form merely acts as a view filter, so although what is displayed on a form looks corrects, the underlying query/table will still have all the records present, hence your report will do the same. Try this...

personally, I would have a new table holding all of the customer details and a generate a cust_ID for the PK for each user. If you add a cust_ID field into the all_items table and link it, away you go! Does this query return what you expected to see?

So basically you want to show all items by Job_No based on existing data. Try the query wizard. Select fields from your two tables, then choose how the tables relate to each other, Ie, Job_No from the job table and Job_No from the Items table. if you then go into the design mode, put some text...

I may have missed the point on this one, but wouldn't creating a query suffice instead of updating field values that are already stored in another table? Wouldn't this cause duplication of the data?

Could try this. We use it. Very good. http://www.christiansteven.com/main.htm

Sorted Now!

Hi all, I've searched this forum and not found the answer to this so far. Is it possible from access vb to open a large PDF, save as optimized and close the PDF. I need to automate this optimization, which I believe is only availble using adobe professional. At a guess, I am thinking I will...

PDF Junction by aquaforest is used to split the file. I can't find the answer on their website. I have successfully managed to reduce the file size using acrobat professional PDF Optimizer then saving it down and splitting, which as a manual process works, but is very time consuming. There is a...

Hi all, I am using PDF Splitter that splits a master document by the bookmarks. The issue I have is that the main doc contains many images, and when it splits, each individual document created is a similar size to the master document even though it is a fraction of the information. I believe...

Ok. So I Guess your table looks something like this then. LoginID Password 1 blue 2 yellow 3 green etc OK, I have tested this and it seems to work. On your form, add 1 combo box and 3 text fields. Set the 3 text fields to visible = no. your combo...

Why not try setting this form's popup and modal to yes. This should force the form you want to be on top and users can not view any other form until this one is closed. (including your switchboard.)

For *, use the input mask wizard and choose password. For password authentification, can you elaborate on how your security is set up? The best way I believe to do this is by using a workgroup file to launch permissions against the database. This will give you the option to assign users to...

I agree with SJ that the chances are the field is not a value that can be summarised. It may be stored as a string. In your field explorer, right click and choose show field type. This will confirm it. You might want to create a formula field and choose... tonumber(yourfieldnamehere) or...

That's great. Thanks a lot.