Search results

Lovely, I will give it a whirl. Thanks

Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed...

Thanks for the comments and the extra legwork. I have now done this through an alternative method but would be interested to learn if this could still work.

Having all kinds of prblems trying to get this to work. I want to read a value of a cell from a closed workbook. I have since read that using the ExecuteExcel4Macro method is the best way to approach this (tell me if it isn't). Dim ACPRanges As clACPRanges Dim arg As String Dim Sheet...

Yes far from ideal but I appreciate your words.

Help needed please on a split database (front and back end). I have completed the split and have deployed the backend to SharePoint. The front end is sat on my (and others) machines with linked tables to the SharePoint lists. This is all fine and works well. However this is where I need help...

Private Sub cmdEmail_Click() Dim objOutlook As Outlook.Application Dim objOutlookMsg As Object Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment ' Create the Outlook session. Set objOutlook = New Outlook.Application ' Create the message...

Great, works fine. Thanks for your help.

I have a report and within the report is a subreport. Within the subreport I have an =sum([HoursRecorded]*24) and the Text Box label control is named 'SumHours'. The Subreport within the main form is named [subreportinvoice]. In the footer of the main form, I have the following...

Great advice works like a dream although I didn't clear any master / child properties. Nonetheless the footer solution worked and displays and prints now only once as required. Thanks.

Ok I will try this and if it isn't what I want I will try to articulate the problem a little clearer. I found it hard to explain. Thanks for the advice.

I have embedded a sub report within a report. I have produced a subreport with all the timesheets on a single invoice so they are grouped one under another. However, when I then embed this within my main Invoice Report I get a number of instances of this subreport. I am finding this very...

I am trying to set my form up so that the user can move between controls with the tab button. I thought this would be very simple but I have an issue. I have 4 labels one below another, and 3 buttons to the right of them, one below another. I want to tab down the labels and then across and down...

I have since discovered that unless all of my fields (notes excepted) are populated it will not attach them in the query and just leaves those records out. I wonder why that is? To get around it, I have validated the INSERT INTO query by ensuring the user populates all fields. Maybe this may not...

That does the trick, sorry for the lack of info in the first post I am still quite new to posting. I was hoping you could help me with one other thing though, not sure if I should open in a new thread or not... In my tblPayments I have 5 records - schema as in the first post. Each of the...

I am using the following code to insert a record into the tblPayments Table I am confident that the values are correct in the query see screenshot and the table schema is: PaymentID, InvoiceID, PaymentDate, PaymentAmount, Notes theQuery = "INSERT INTO tblPayments " _ &...

Great stuff. Thanks :-)

I have three tables, Invoice, Timesheet and Linker. Invoice can contain several Timesheets and any client can have a number of Invoices. The Linker table stores the InvoiceID and the TimsheetID so I can keep track on which Timesheet Records are attached to any individual invoice record. Here...

I know there is a way to show a conditional 'New' field button or something similar to that in the screenshot on the next available table record. =IIf(IsNull([LinkerID]),"(Add)","Remove") I have tried to copy the method behind this from another of my tables which works but it is not working...

I think I was referencing the TextBox Handle rather than the TextBox which contained the summed value and was probably the reason why it was blank. Anyway, done that now and all working. Cheers for the help.