Search results

i think what you want is a continuous form, which will update as you fill it in if its linked to the table directly.

for the record source try: SELECT table.[ID], table.[name] FROM table ORDER BY [name];

try changing the bound column to 1 or 2

in the properties, set the first column width to 0, the second to 1", or however wide you want it. so, it will look like this: 0";1"

can the acess 2007 free version run on windows xp?

why not cascade delete on the relationship?

Try using one query. This might help: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=285 it writes the sql for your query based on your selections, you can then filter the fields afterwards.

I figured it out, had to set more indexes and rearrange my relationships, thanks

for the querying, what about something like this? http://allenbrowne.com/AppFindAsUType.html

I want to comment on a counterparty given a certain product. so, counterparty A and product X have a comment, counterparty B and product X have a comment, counterparty A and product Y have a comment, etc.

Hello again, I am trying to have users be able to see and enter comments on a form along with results from a query. My database looks like this: the "comments" table is what i'm having problems with. Right now i have a query where a user selects a product and any number of funds and it...

I have this table in the relationships, but i dont know how/what to link it to? I need it to match up with the details section of a form that comes up with Counterparty, given a product

Okay now i have another problem with my relationships, i need to add a comments column that is linked to a specific Counterparty(as a whole, not the entities) and a specific product. For example something like this: Counterparty A, Product A, "not preffered" Counterparty A, Product B, "Quick...

thanks keith, i think i got that working now

oops, the company is the counterparty. Each product can be traded in each fund, but only certain companies(counterparties) will do so, hence why i am making this database so i can easily look that up. Right now the combine table looks like this: Counterparty ID, Product ID, Fund ID, Avaiable...

I will try to explain this as best as possible, please let me know if there's any more info i can provide in order to get a better response. I am making a database that links the following tables: Product Fund Company The value for each of these combinations will be a simple yes/no, but the...

Thanks for your input, every bit helps. After searching for hours i think this may not be feasible for me because i don't know enough about sql.

I see the empty unbound text boxes but no information is put into them. I get no errors at all, however when i compile it i have problems with the formatcount function. After looking it up it says that it's only used to reports, is there a form equivilant for this function or is this whole code...

Hello everyone, I have a bit of a complex problem (for me anyway). I need dynamic fields in a form. I got them to work on a report using the microsoft tutorial here: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320 but i can't get it to work on a form. I basically tried to copy...

Okay, i figured out how to get the data into the format i wanted, but i still have a more complicated problem. Is there any way to have variable fields in a form or report? eg. right now theres products a,b,c,d but if i add e it will automatically add this column to the form/report?