Hi Paul, What is the name of the field in "frmFinancingDetails" that you are trying to match? I would have expected it to be "InvoiceID" and not "Invoice". If...
Hi Jesse, I've just noticed the 'Docmd.Save ,""'. That would save the form and not the record. To save the record, use: Me.Dirty = False Regards, Clive. ... ...
Hi Jesse, You have given us the clue. ... Percent format takes the stored value, mutiplies it by 100, and displays % on the right. With types, LongInteger,...
Hi Michael, In the case of property management I can understand the the need for many to many relationships. It also depends on whether you need to maintain...
TY Bill, I am just being a hard headed jerk on this issue. To me, it just seems like such a simple, natural piece of functionality. Yes, I understand the...
Terence There is a sample database in our files called MouseMoveExample (catchy name, huh?) that uses the MouseMove to "highlight" the label for a command...
TY Bill, I just wanted to apologize for being such a stickler re: mouseover. It just seems like such a natuaral event. I am also not particularly a fan of...
Hi Terence I saw the first one. I still think you should look at the MouseMoveExample in our Files>Samples folder. You don't have to do anything with the...
Bill , OK you got a DEAL, Today i have some time to devote to the cosmetics of the application..................I will build a test bed and try it, I...
Terence Our cat *tolerates* our dog so, yeah, they live together. <g> Bill ... bed ... cats ... of ... not ... probably ... never ... MouveMove. ... it...
Hmmmmm, this is un Nearving. I am not uch on examples and samples, so i embarked upon reading and expermenting. The MouseMove does trigger I can work out the...
Hi Everyone, Hope all is well... I have used the following logic to import excel file. It seems that the excel-columns have to match the access-columns....
V Hi – As I’ve just started with VBA over the last couple days I’m finding that there is a lot that I want to do with not much clue on where to start. ...
I have asked a couple of questions on designing databases and one theme is to have everything designed before you start configuring Access. That certainly...
Jan, I like to use Visio to document new or even existing DB's. You can define everything all the way down to individual field properties in each table - and...
Thanks Jesse. I actually have and use Visio. Only for data flows. Could I see something you have done? Something simple please. Thanks Jan ... define ... ...
Jan, Sure, I'm in the field at the moment but when I get back to the office tonight I'll send you something along. I'll send it directly to your yahoo email...
Hi Everyone, I just switched to A2003 office. I remember in A2000 being able to see boundary lines separating labels. Does anyone know how to turn on...
Michael Usse the Click event for the button. If you only want the current time you can use the Time() function. If you want the Date and Time use Now(); For...
Jan I start with an Entity Relationship Diagram (ERD) in Visio or whatever I have for flow charts. Once you have that part done you can build the database. I...
Thanks Bill –  I will give this a try..... I'm slow but I'm learning  As for data formats I only need time.  But my understanding is that the data...
Hi Sandra, What you can do is to either link to the Excel Spreadsheet so that it appears as a linked table or to import the Spreadsheet to a new table. You can...
? Are you doing this only in Access or are you creating labels in Word with Acess data? If the labels are set up as a mail merge with Word, then you can show...
Hi Sandra, Are you talking about Label BorderStyel? If so you can set them to Transparent, Solid, Dashed etc. in Form Design. If it's not that then where are...
Dear All, I am using several unbound search boxes in form header to display the search result in a continuous form, based on the criteria entered in these...
Dear All, The following piece of coding was working well until today but stopped working now and I can't figure out what is wrong. Require your help in setting...
thx Everyone, I did table/show grid lines and it worked! thx, Sandra ... From: Clive Williams <zctek@...> Subject: [MS_AccessPros] Re: A2003 to Word for...
Hi, Just like the title says, can you store control names as part of an array? I'm writing some code that checks required fields for entry values and if they...
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.
