Search results
-
D
Updating table based on Max Values
I am currently trying to update a table with the Max values from the below query. select debtepisodes.accounts1,deepisodenum,Max(dehepisodenum) from debtepisodes,debtepisodeshistory where debtepisodes.accounts1 = debtepisodeshistory.accounts1 group by debtepisodes.accounts1,deepisodenum... -
D
Text box based on a query
Hopefully this is something quick and easy i currently have a form which is using a particular query to populate the fields etc. I have one field that i need to be based on a seperate query altogether, i have tried almagamating the queries but this does not work, Is there some code that will... -
D
Comma Replacement Query
Prob a real simple answer to this issue that my colleague is having, Is there a way within an updat query that ",," can be replaced with "," we have tried placing these into an update query but it doesn't seem to pick up the ",," as they are mid string on the table. -
D
The Microsoft Jet database engine cannot find a record in the table <name> with key m
The Microsoft Jet database engine cannot find a record in the table <name> with key m Right then people this is probably something mega easy but i am having a mare with it at current as no matter what i try i get the above error, I have a parent child relationship based on a Primary key... -
D
Making a report look like a letter
I am currently working on a report which i am hoping to use as a mailshot, The issue i am having is i have 9 text boxes containing address details in a letter format as shown below. If one of these boxes is null then i am left with a gap in the address which is not ideal for a professional... -
D
Dcount as control for text box
I basically have 2 questions, First question is can Dcount work based on a query as opposed to a table and then if it can work on a query could someone let me know why my following dcount code is not working or if i am just being a little simple, Basically i am trying to do a count based on a... -
D
Form Orentation
At current i have a form which has an action taken combo box, on the selection of a specified action taken it opens a new form to be populated but..... and here is where my problem lies, The form it opens it opens in the center of the previous form wheras i need it to be opened in the right hand...