If you are using Access 2000 -- There is a bug related to the new "Track Name AutoCorrect" feature. Try turning this feature off and see if the printer settings remain as last set.
From the Access menu bar...
Tools/Options/"General" tab
Jim Conrad
JimConrad@Consultant.com
I assume you have a form with two controls. I'll call the checkbox control "chkBox" and the text box that will hold the date/time, "txtDate". You can set the "visible" property of txtDate to "true" while you work on the form and reset it later to...
Sounds like you have multiple issues to deal with :-(
Are you having problems with creating an email?
Storing the "reorder point"?
Deciding where to put the code?
Jim Conrad
JimConrad@Consultant.com
Did you add this code to the NotInList event procedure?<br><br>Response = acDataErrAdded<br><br>This tells Access that new data has been added and it should requery the db. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
Assuming you have already imported the Excel data and that F1-F7 are the fieldnames in the imported table... then a "append" query is all you need.<br><br>You probably will want to make a copy of your "Form Element" table before you start, in case something doesn't work while...
Your might want to view <A HREF="http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm" TARGET="_new">http://www.microsoft.com/ACCESSDEV/ProdInfo/snapshot.htm</A> for information about the Access Report Snapshot Viewer.<br><br>You can create a snapshot of a report into a file that your user...
Maximum database size is 2 gigabytes.<br><br>Maximum rows depends on number of columns (max of 255 per table) and type of data. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
VBA is Visual Basic for Applications.<br><br>Check <A HREF="http://www.microsoft.com" TARGET="_new">www.microsoft.com</A> for more details. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
Watch out for Edited Record option. Unfortunately Access does not lock individual rows of the database. It locks "pages" which are sets of 2000 bytes. So if you have a small table (just a few columns of data), you might have 10 rows of data sharing a...
You can just single click the subform and make changes to it while viewing it in the context of the mainform.<br><br>But I liked it better in Access 97, too. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
Try the Microsoft site <A HREF="http://www.microsoft.com" TARGET="_new">www.microsoft.com</A> and search for ASP. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
Set it up exactly as you planned. Assuming your table is called ReportSeq and the numeric column is also called ReportSeq then...<br> Add the ReportSeq table to your query (do not link it to your other tables), add ReportSeq column to your query grid... <br> Add...
<FONT FACE=monospace><br>Dim LateObject As Object ' Late binding<br>Dim EarlyObject As Recordset ' Early binding <br></font><br>Access can help you write your code when you use Early binding since it knows that EarlyObject is going to refer to a recordset type...
Try this code attached to MyButton on the form with NumberOfRecords as the name of the unbound textbox<br><br><FONT FACE=monospace><br>Sub MyButton_Click()<br><br> Call BuildRandomTable(NumberOfRecords)<br><br>End Sub<br></font> <p>Jim Conrad<br><a...
Or try...<br><br>Note: Listbox columns are zero based index, so Column(0) refers to the 1st column...<br><br>[Forms]![RunProductionQueryForm]![List21].Column(1)<br> <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
The "Controls" collection is indexed in the order the controls were originally added to the form.<br><br>If you are trying to set some of the control properties (but only for certain types of control), you can use the "TypeName" function or "TypeOf" if...
You might want to hire a consultant for a few hours to get you started.<br><br>You may want to take a class in beginning programming.<br><br>You are going to find that, although Access is good at doing some simple things, your needs will almost always exceed what can be done...
Sorry, but it isn't clear to me what you are trying to do. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.