Search results

Ok, it sounds like you are using Parameter criteria in the queries ( square brackets around question).. They will pop up anyways because they are bound to the report. When you added the subreport did you link it to the related field on the main report? look at your queries run them...

doesn't sound like a good idea for a query, make a Report and set the page to 2 columns.

check here if you are using Access 2007 http://support.microsoft.com/kb/931407

Ok, I made some changes to the database to try to explain what I mean. The way I have isn't nescesarily the way you might want it, but just take a look. As I see it first a site is created, then you create the Schedule details..each site has MANY schedules? I base that on the fact that you...

Hi Stephen, I took a look ( I had to recreate the subform), and I am not clear what value and from where the "applicantscheduled" field is to be populated. I see you have an Applicatant ID field also, and this is still leading to the point I was trying to make.... It would appear to me that in...

This part sounds like you are trying to duplicate data that is already entered. Related data should not be copied to another table when it can be referred/linked to. It is easier to help if you can post a sample DB ( no personal info)...strip out anything that is not relevant.

just make sure you understand the effect, if all 3 tables contain a single record per item then it will work great. If one of them contains multiple records of an item...in the case of lets say an Order Detail ( history) then you will see repeated records when you might not want to. In other...

start a new query and add the tables to the design grid. because there are 3 it is best that one table be the primary one. click on the item from the primary one and drag over to the Item on the secondary...do this for both...then double click on the lines until you get the "Join Properties"...

no problem naungsai , glad to help...it helps to hang around sites like this, you learn alot from helping others. Happy New Year

ok based on your last post, I thought it would be best if you had a criteria table. Here you can enter what ever date expression you want to put into query, the code will put it into the SQL. I made a form that has a combo that selects the criteria Option Compare Database Private Sub...

I can't decide the best way because I don't have all the parts...if you post a sample DB with sample data it might help give you a better answer. The easy way is to make 3 queries using the function I gave you, and then make 3 reports...I think you have to anyways because of the "Grouping"...

use this function Expr1: DatePart("q",[yourDatefieldname]) "m" for month and "yyyy" for year

Just use this in the query field criteria and set your form control with a default value (in properties) of "*" Like([Forms]![Clean Solvent Reports]![Sales])&"*"

ok, I see what you mean now. I haven't used that new Multi Value combo, but it sounded like you needed to adjust the "bound" column in the properties? But at least you got it going

Good Call George, I am getting used to that myself ( the 2007 changes), but I haven't run any new code in 2007 version....I'll have to add that to my checklist :)

Modal forces you to act on the form, but not sure if that is your problem. with the switchboard which option did you choose when opening the form..edit/add, did you change any form properties...try running the form on it's own ( without switch) also for debugging is there any code in the...

what version of Access? and what method are you using to Open the form (switchboard or you own)?

very good, glad to help * you can mark this thread solved...in thread tools

It's easier than you think, replace those parameters, with the names of controls on the form, they can be simple text boxes or combos that select data... Now the syntax to replace you [Square bracket params] is this... Simple: forms![YourformName]![YourcontrolName] better if you want a...

sorry, I lost you...are you importing to Access? For a CSV you should create an import spcification and save it, you should be able to choose ";" semicolon as the delimiter.