Search results for query: *

Thanks Chaz, that's an interesting idea. I think that Dropbox provides a fantastic solution to getting an update from my computer at home to my client's offices but the deployment from his Dropbox folder to each of his user's machines has to run invisibly without affecting their use of the...

OK, problem solved but it was not easy because my dos skills were rusty and I didn't realise (do now) that MS have varied the Dos command structure with each Windows implementation. Essentially I have used : Ren, Rem, XCopy and Del commands to achieve my aims. When I update my front-end...

Yes I think you are right. AS you can see I tried making the bat file wait half a minute, which is way long enough for my front-end to close fully. Question is how to get around it. Rod

Hi Everybody, I have been using dos .bat files to carry out some file management in the background with the batch files being called from within a form's vba module. This is working fine except in one particular scenario. I send my client an updated version of the front-end via Dropbox. The...

strongm, thanks for that. I didn't know about WMI. More reading to do but it looks promising. John, do you mean a dos style .bat program? Rod

Thanks guys. You have given me some great information here. The big issue for my problem is that the target pc which is the host for my back-end database does not have a front-end running on it. In fact it's in a room on its own and nobody uses it normally, especially not at night. I have a...

Machine 'A' and machine 'B' are on the same LAN. In the specific scenario I am concerned with right now machine 'B' is running Windows 10, while machine 'A' could be running 10, 7 or XP. i.e. there are several machines, with varying OS's, currently on the LAN that might need to perform this...

I'm guessing the continuous form remains open while you update the records otherwise if you had closed it and then re-opened it the calculated field would calculate the value. I suggest that in the continuous form you add an 'On Activate' procedure with a simple line that names the field with...

Hi, My solution would be that you create a pdf of the invoice, using a pdf writer which installs as a psuedo printer. CutePdf (www.cutepdf.com) Works well. An invoice printed to a pdf is fairly tamper proof. Then archive the records to a secure table that no user form has access to except maybe...

Further info... I have come to the conclusion that the Microsoft registry is out of wack. Previously I was running Access 97 on this machine, with no problems but I had XP remove Office 97 before installing the new 2003 version. The MSOffice 2003 installer asks whether it should remove...

I have just finished installing Office 2003 (including Access 2003) on an XP_Home system and I find in the Get data Import File dialogue that there is no option to import from a CSV or TXT type file. The only available supported file types are: Microsoft Office Access mdb; mda etc. Windows...

Good on ya Mom! Leslie, you might tell her she should also charge 25c for inapropriate use of "like". As in, "I was like standing by the bar." or, "I was like really bored. Know what I mean." Rod

jsteph, I'm with you. Up In Smoke: best moment for me is when the motorcycle traffic cop has been following the dope encrusted van, all the while breathing in smoke from the dope burt by the hot exhaust pipe. Finally he stops the van and sidles up to the drivers window. Cheech or Chong winds...

Hi Steve, et al, check this site out: http://www.mangovision.com/vbapi/ref/index.html This chap has done some sterling work explaining many API functions, although I don't seem to be able to get the EnumWindows and EnumChildWindows functions to work properly. Probablly me. I did get to flash...

Steve - good question. I've got a similar requirement. So I thought I'd piggy back onto yours and with a bit of luck some kind soul will... I need to locate an open window with a known name. To be specific "New Message", being the title of a new Outlook Express message window before the...

Try playing around with this: Function getActiveForm() Dim strFormname As Variant ' so it will handle nulls when no form is open 'set strFormname = currently active form name strFormname = Screen.ActiveForm.Name If IsNull(strFormname) Then MsgBox "No Form found" Else MsgBox...

Try this: SELECT Format([IDATE],"hh") AS Hour, Sum(TMP_Daily_Table.TAGVALUE) AS Totala FROM TMP_Daily_Table WHERE (((TMP_Daily_Table.DISPLAYNAME) Like "Collector 2A" Or (TMP_Daily_Table.DISPLAYNAME)="Collector 2B") AND ((TMP_Daily_Table.ID)="DSK")) GROUP BY Format([IDATE],"hh") HAVING...

When you import the spreadsheet you imported the data into an existing access table whereby each new table record equals a row from the spreadsheet. Probablly the easiest way for you to delete a single row on a regular basis is to create a DELETE query using the Query Wizard whereby you specify...

Zameer, Thanks for the update, an useful site. After posting my query I did manage to create my own solution but thanks anyway. For anyone who is interested, if the code below is placed in the On Print event of a report's Detail section then any text boxes with names that begin with "v" will...

I am designing a report to print labels to a specific layout format. I need a way to detect when the text in any given text box exceeds the available space in the text box (over fills its text box) so that the font size can be reduced programatically to allow the text to fit neatly within the...