Search results

Just wanted to get thoughts and the preferred way to link a table. Linking all tables permanently or linking them through queries using the IN clause?

I need to create a query that joins two tables on a one-to-many. However I only want to see the most recent related record on the many side. Not sure how to set that up.

Base the report on a query. Then in the query create fields for the calculations like this: current quantity: acquiredquantity-salequantity current value: acquiredprice-salevalue Then you can place these fields in the report without the fields it uses to perform the calculation.

What I would do is base the form on a query that uses this textbox for a parameter. The criteria would be: Like Forms!FormName!TextboxName & "*" Then all you have to do is use the button to requery the form. You'll probably want the form to show all the records if nothing is in that textbox...

This is the standard code I use to link: Dim db as DAO.Database Dim tbl as DAO.Tabledef Dim strPath as String strPath=Path & name of backend Set db=CurrentDb Set tbl=db.CreateTableDef("Name given to table") tbl.Connect=";DATABASE=" & strPath tbl.SourceTableName="Name of backend table"...

What you could do is setup a lookup expression in the command button's event. Something like this: If Not IsNull(DLookUp("[ID Field]","[Table query is bound to]","[ID Field]=" & Forms!frmSearch!Listbox)) Then DoCmd.OpenForm "frmTracking", , ,"[ID Field]=" & Forms!frmSearch!Listbox Else...

I assume if you use a select statement such as this: SELECT TOP 10 PERCENT without giving it an ORDER BY clause then it will randomly pickup 10%.

I gotcha. In order to make a popup form work you'll need to create a hidden textbox on the popup form that is bound to the foreign key field. In its default value property type this: =Forms![Form bound to one side]![Primary key] This way it will automatically add the foreign key for you...

Do you have the child and master links setup correctly. Everytime you add a record in the subform it needs to place the correct foreign key into the subform record.

I'm trying to set this up through code. There's got to be something I can tweak.

In the frontend I am trying to copy a table and it's data from the backend to another database. But when I use TransferDatabase all it does is copy the link into the new db. I don't want a link, but an actual copy of the table.

Eland -- There's an error with the SendObject command in A2k. Nothing you can do about it. Best thing I recommend is since you're using Outlook for email you can set that up through code without a problem. Sending an attachment requires an extra step. You have to export to a file and then...

It's got me a little bewildered too. I've gotten this same code to work. You can send me the db. robert.mills@zcsterling.com Don't compress it. They haven't given me access to zip software at work.

I was having similar problems on my apps. The network was terribly congested and some forms were taking over 2 minutes to load. And in some cases things were so bad that the user couldn't even type in data after it opened. I accomplished The Doc Man's 4th suggestion by replicating the...

Use the iif statement. It's just like using if in excel only with an extra i.

I have created a split db and use an MDE file for the frontend. Now my NT guy has created a script that runs when users login to their computers. It compares the date stamp of their local FE to the FE on the server. If the date stamp of the server FE is more recent then it copies it to create...

How bout that. Who do you work for?

As for the checkbox I think setting its default value to false will accomplish what you want. I've had similar problems with the page setup being changed and I haven't figured out how to prevent that.

The way I achieve this is by basing my report on a query. In the query I include the table with the data plus the table where you store the subjects. Create a relationship between the key field in the subjects table and the field in the data table where the subject code is. Then you make one...

You know I think Pat's was easier. :D