Search results

Is there a vba way to check for internet connection status before launching into procdures which assume a connection is present? Matt

Will that work with this TsiCompact.dll? The prompt while in the IDE lists only Source and Destination. The rest pop up as properties when you put the "." after m_jet. Matt

If anybody has used the TsiCompact utility from http://www.trigeminal.com perhaps you can help. The following code correctly runs the CompactMyDatabase function from a class module if I'm compacting a database with no security setup: Public Sub CompactMyDatabase(Source As String, Destination...

I am writing a procedure for a combo notinlist event. A form for data entry pops up to allow some data manipulation etc. when the event is triggered. However, I still get the default message box (in addition to my own form) informing the user that "The text you entered isn't an item in the...

I tried your code and noticed a couple of things. First of all, I don't know your format for dates and numbers. What format is a ModuleID? Two numbers, four? yr = Year(Session) 'This gives me a four digit year. Assigning the Semester works well. strSecID = yr & sem & "M" & ModID & "-" & 0...

You're right, of course. My algorithm is too simple to work. I guess an iterative process of checking for empty priorities and bumping up the ones below if found. Or the query could leave intact all priority numbers greater than the current record's initial value, and bump down all...

Duh. DoCmd.Close I found this little command further down in my code. I assumed that since it was in the popup form, it would close the popup form. Instead, it was closing my main form and leaving the popup intact! I have since found my own answer. Thanks for letting me sort through this...

If you place the query in the "afterUpdate" event of the control, then all priorities would be reassigned whenever one was updated. No user intervention required. Matt

What is the error message? Matt

A query should work whether the field is in a separate table or merely a field in the main data table. Jack's concern is more likely to be a problem. Matt

I haven't written this out, but it seems that you should be able to do this with a query. Assuming you have just entered a priority number into some control, you could query for all records with a value <= the current priority. This is because the current reprioritizing will not affect records...

Search for "synchronized forms" in the MSAccess help (F1). There is a section on using the "OnCurrent" event of the first form to maintain the synchronization of a secondary form. That probably has your answer. Here's the code: Private Sub Form_Current() ' Declare and set a variable to...

I have a nested form structure: frm_Fish_ID contains: frm_Pathology, which contains: frm_PathMetricEdit. The Pathology form is linked to the main Fish_ID form through linking fields. The PathMetricEdit form is linked, but the data source query allows only edits, not data entry (because of a...

If you enter this in your HOTSHOTS_WORKSHEET form Access will probably tell you that you can't assign a value to an autonumber field. Try it in either the ADDENDUM or INVOICE forms. I usually put the code in the focus event of the first control. The field you're trying to put the PRO_HSTA...

If your subforms are embedded in your main form, the links should update the child link field in the subform. If you are opening the subsequent forms in separate windows, you might try using the "gotfocus" event of the first control in the secondary form. For instance: If IsNull(Me!Record_ID)...

Alan: Thanks for the reply. I tried to call the OnCurrent for the subform (from code in my popup), I was told the object does not support that method. When I put code in the popup instructing the subform to requery, it closes the entire main form down, leaving me with the popup window all...

In my attempts to control the users, I have lost control of one of my controls. I have a subform with stacked controls. In the "ON Current" event of my "Metrics" subform, I check for data in two bound controls. If they are null, I make them invisible; a large button is made visible to cover...

I am currently trying to tie a custom help file into my database. I can't offer you the final solution because it's not working perfectly for me yet, but I'm attempting to use "HTML Help Workshop" from microsoft. It is installed with the developer edition but even if you don't have it, you can...

Thanks, Jack. I was trying to avoid a sub-sub form, and still have editable data. Would DLookup give me editable data? Apparently, if the form is based upon one table or query, the only way to edit data from another source is through the use of sub-forms? I've already implemented it that way...

Hello. I have a form based on a table. I would like to have a text box control on the form which has as its source a sql statement. I have a valid sql statement - When used independently the sql generates an editable result. When I put the sql statement in the "Control Source" property of...