Search results

The best way to accomplish that would be to use Excel. :eek: But, in all seriousness, the first thing you must train your mind to do when learning Access is to stop thinking in terms of Excel. They are different programs that do different things. Based on what I've read here, I think what you...

Sorry to keep resurrecting this old thread, but I was able to add some functionality to Bob's utility and wanted to share what I'd done. My development environment is several times zones away from my customers and I have no access at all to their network. While this utility really helped with...

I've created a way to solve the name mismatch issue: In my master front end, I added an additional table: tbl-version_master_name with a single field named s_mastername (this follows the convention used in tbl-version_master_location). I added the name of the master (complete with file...

I'd like to think that if I'm capable of deciphering most of the code contained within Bob's utility, reading a date is not beyond my ability. I'm aware of how old this thread is. Using the forum's search function for "auto update utility" gave me this thread as having the most recent activity...

I just looked at the batch file itself:Echo Off ECHO Deleting old file ping 1.1.1.1 -n 1 -w 2000 Del "D:\update test\front end\NIS_test.accdb" ECHO Copying new file Copy /Y "D:\update test\master\NIS_test.accdb" "D:\update test\front end\NIS_test.accdb" CLICK ANY KEY TO RESTART THE ACCESS...

Now that I'm trying to test the actual updating process I've encountered more problems: If I get a version mismatch, the message box notifying me that I need to update appears as expected. Clicking OK closes Access, creates the batch file and opens a cmd window (minimized). While watching the...

Bob, The link in that thread doesn't work, however http://www.btabdevelopment.com/ts/freetools looks like it may be the new location of this tool. However, I can't seem to get it to work: I'm using Access_Front-End_AutoUpdating_Utility_rev06Sep2008 from the page linked above. I'm developing in...

^ what he said.

I was bored so I made this easier to read: Private Sub cmdLogin_Click() Dim login_validation As Variant login_validation = DLookup("Password", "tblLogin", "Username='" & Nz(txtUsername.Value, "") & "'") If Nz(login_validation, "") <> Nz([txtPassword].Value, "") Then MsgBox...

good stuff!

try =IIf(IsNull([SummaryLine]![Price]),[Material]![DefaultPrice],[SummaryLine]![Price])

Not sure I'm following exactly since I haven't dealt with emailing via code, but I've faced a similar issue before. Mine was trying to save a PDF of a report as it closes. What I did to deal with it: Create an identical report. When the original report is closing, it opens the other report...

Is there a particular reason you're hesitant to use queries? It's kinda what they're there for. The math could be done for each column inside the same query. You'd just have to point your text boxes to the appropriate part within the query. For instance, =DLookUp("SumOfCalculation1","tbl1...

so, you want the text box at the top to sum all of the entries in the calculation1 column? I created a query to do that math and then pointed your text box to it. If this isn't some stripped down version you threw together to show your issue, I'd suggest looking into naming conventions for...

Here's how I did it This code runs on a hidden form on a 5 minutes timer:Private Sub Form_Timer() Dim LocalTime, StartWindow, EndWindow As Date LocalTime = TimeValue(Now()) StartWindow = TimeValue(Me.lblStartWindow.Caption) EndWindow = TimeValue(Me.lblEndWindow.Caption) If LocalTime >...

Here's the finished Form_Timer code with the Else in place. This utilizes two hidden labels (lblStartWindow and lblEndWindow) to control the times. The timer interval is 300000 (5 minutes) so it only fires once per window. Private Sub Form_Timer() Dim LocalTime, StartWindow, EndWindow As Date...

Got this one resolved. I did away with the Do Loop and added two labels to my frmMaintenance. The first label's caption is my "start window" for maintenance and the second label's caption is my "end window." Both labels are set to visible=false. I make use of the labels with the following...

Figuring out the Else has been moved to this thread.

I'm using the following code: Private Sub Form_Timer() Dim LocalTime, StartWindow, EndWindow As Date LocalTime = Format(TimeValue(Now()), "hh:mm") StartWindow = #11:46:00 AM# EndWindow = #11:48:00 AM# Dim Response Response = MsgBox("Run scheduled maintenance?" & vbCrLf & vbCrLf & _...

The final code for anyone who stumbles across this thread looking for answers to similar issues. The Module: Option Compare Database Public Function CompactDB(TableName As String) As Boolean On Error GoTo Err_CompactDB Dim db As DAO.Database Set db = CurrentDb Dim stFileName DoCmd.Hourglass...