Search results

CJ, this assumes the text file has line delimiters. If it is a fixed-length record text stream, you would want to use random-access IO File Read. FWIW, I think the problem is with the ADO recordset not releasing allocated memory. I would try using a DAO recordset, and if necessary do a...

I have noticed that the subfolder for the excel files is "utility" but for the cvs file it is "input". Do you have the csv's in the correct directory? Best, Jiri

It's Vladimir. Like Putin. :) Best, Jiri

If the two controls are on an unbound form (as it looks they are) you could simply add the statement txtbox1.visible = False to the OnLoad event. Best, Jiri

I agree. Best thing is to save the whole BE of the database, before deleting anything from its tables. Using data stamp in the name of the saved copy will help retrieve the correct backup copy to which you may want to roll back. Here is an example how to back up the whole BE file with a date...

One more thing, Arnel. The back-and-forth conversion btw asc numerics and letters is what is called for but your method has a problem on this line: c = DMax("theAutoGenField", "theTable", "Left(theAutoGenField,3)='" & julian & "'") & "" Since you are comparing strings of unequal length you...

You are right, my bad. :) Best, Jiri

Why wouldn't you give the gent what he wants? It's not that much of a big deal. Public Function GetJulianInc() As String Dim jl As String, ljl As String, hival As String, lchar As String, acode As Byte jl = Format(DatePart("y", Date), "000") hival = DMax("jul", "Jtable"): ljl =...

Try this, = DLookup("[Ser_charge]", "[Service_Charges]", "[Service_Type] ='sert' & AND [Engine_power] = " & engp) Best, Jiri

Hi John. My own experience with a back-end on WAN via VPN gateways has not been good. Even with a fast network, we had frequent db corruptions. They seemed to occur regularly if a workstation had paused in communicating with a server for any amount of time. We never found out the cause of the...

Like Colin, I have generally avoided Tempvars, in preference to global variables. I have however changed my standard in favour of "system" parameter variables kept in a table. Here are the benefits of the approach: It groups variables for easier retrieval and control. It simplifies the access...

No problem, Colin.

Here is a code sample. There are some externals to this but the methodology of a timed-out session should be hopefully clear. The code is class module to a timer form that runs in the background. The splash screen with a counter becomes visible two minutes before shutdown (this splash screen is...

Hi, you can prevent the machine from going to sleep during the program execution by this API function: Enum Execution_State ES_SYSTEM_REQUIRED = &H1 ES_DISPLAY_REQUIRED = &H2 ES_USER_PRESENT = &H4 ES_CONTINUOUS = &H80000000 End Enum Declare Sub...

Just curious: on which line of code do you get the error after you comment out the line it caused the problem previously? Best, Jiri

Sparky, the technique I use for a task like this is create a template excel sheet, and then, after getting the user report parameters through multiple choices, dump the data via Access VBA into a copy of the template Excel sheet. Best, Jiri

Hi Jess, I noticed that in the Qualtrics C&D Links structure there is no "header" item in the "message" member. The line causing the error dicMessage("header") = dicHeader looks strange because it is supposed to point to another dictionary structure, which is already defined. Have you...

Hi, I have a hunch that Ranman is on the right track and the issue has to do with mismatched references to Microsoft Excel XX.X Object Library. The problem is that sometimes the upgraded reference does not work. What you might want to try to do is to uncheck the reference, rerun the program and...

I had a similar issue a few years back and the problem was caused by corruption. I followed the process suggested by Allen Browne. Amazingly, the page is still on the web: https://bytes.com/topic/access/answers/205691-bug-locked-another-user Best, Jiri

I have a setup for auto backup that directly addresses this using a timer, and two values in a parameter table, 1) auto backup time interval, 2) time auto backup last executed. When timer triggers the action i.e. last occurrence + interval >= Now(), it 1)disables the timer for the duration of...