You are completely right. Why would someone create controls by VBA? Isn't easier to do it by visual tools? Certainly. However, I have an important constrain:...
John, Thanks for your prompt response and apologies for my "thickness", but I don't seem able to get your suggestion working. I replaced the table / field...
Keith- Please post the SQL that you tried. PD2 is an alias for the second copy of the table inside the subquery so that the inner WHERE clause can explicity ...
Luciano- Don't give up! Yes, you can write VBA code to build forms or reports and add controls. Unfortunately, you can't use the Immediate Window to directly...
John, I noticed my error (I put a comma instead of a full stop). Having corrected that, the error is now "You have written a subquery that can return more than...
Keith- I gave you SQL that goes in the SQL Window. You cannot paste that on a Field line. Switch to SQL View and paste this: SELECT tbl_Insurance.* FROM...
BEAUTIFUL! Thanks John. I'm going to have to get a VBA code book for my collection. ... types. Try ... Integer, _ ... Integer, _ ... Integer, _ ... ...
I am currently working on a document database [ all formats ]I want to access the documents [stored externally] and keep a record of the files in the database....
I am running a monthly report using Excel as my table. Is there a way in Access 2003 where I can sum up all the records of one field? My report is a commission...
John, You must get fed up with people like me!!! Works first time when you do it correctly. Many thanks for your help and patience. Keith ... on a ... ...
I need to create instructions for my end users on how to use this database each month when they submit their cost adjustments. Right now I have it in a form of...
Tried that and it works, but I need an actual rank assigned, like a an added field(1-6) for each group, so that later in a query, I can do whatever I want...
Can you imagine the size of the bennefit you have done for me? Can you imagine how long I have been waiting for this reply? I didn't have test due to work...
Hi, John. Thanks for your help. Have You any news about this Access 2007 Bug? Do you received any response from MS? Best Regards ... You can't ... first ... ...
Thanks, but I've tried that. What I need is a specific rank assigned to each of the 6 companies in each group, essentially creating a new field from the rank,...
Luciano- I hope you find my code useful. If you have any problems with it, please be sure to let me know so that I can try to make it better. John Viescas,...
They're looking at it. For what it's worth, I was able to reproduce the bug in one of the sample databases from my book, so it's not something specific to...
Hi, Is there a way to format a concatenated field which holds dates to Long Date? Although the format is set to Long Date in the Property Sheet it is not...
Hey Joe! Nice to see you again! I would love to give you some advice on this, but could you give a little more detail about workflow and what you're trying to...
Keith- Glad to hear it works now. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access...
Like this: =Format([inceptiondate], "Long Date") & "To" & Format([expirydate], "Long Date") Setting the format of the field in the Property Sheet applies only...
Chris- I would think a Hyperlink field in an Access table would do the trick. As I recall, some versions of Access (pre-2007) insist on slapping http:// on...
Joe- You have to stop thinking like a Spreadsheet. <s> It's really simple to add "totals" to a report in Access. Create a Group - perhaps on InvoiceID - and...
Joe, You have a few options to achieve the desired results. First, and simplest in my opinion, is to open your form in Design View and display the form ...
Please post the SQL from the query as you have it now. I'll show you how to add a "ranking" column using a subquery. John Viescas, author Microsoft Office...
Yes, Yes , Yes. Its works. Thank you very much John. Thank you again. ... reproduce the bug ... specific ... complex ... They'll ... network ... then use an ...
Joe- Set the Allow Edits property of the form to No. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications ...
I am only using Access to manipulate my data, then put it back to Excel to submit to our finance department. These instructions I do not want the user to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
