Search results

I have been playing with the idea of outputting to a file for tempoary storage some data using the input output append methods. However, when I search help on these topics my help loops into a crash. I am using Access 2000. So far I have written the following code which certainly creates the...

I have a form acting as a switchboard. Behind the form I have time driven events based on checking a second form every 1000 ms. Everything works fine, except I do not seem to be able to move the focus off my switchboard form when minimised to be able to minimise access. Any suggestions please

I solved the problems thanks guys. Apparently if I send the table I am limited to 50 records only. If I send the table instead I can send 300 records (tested so far).

No my floppy disk is not full I can check this by the run hust before which is 48 pages, this takes around 14 kB. My real problem is that once it is saved on the floppy I then need to be able to reimport it into my machine.

Function DCHL() stDocName = "rptDynamicChl" I have the following code through my application, the save to A drive works well for the first five reports. The last report is 50 pages or more in length, and I receive an error. There is no mention of a limit on size in an XLS output to format...

My application has a master switchboard, for directing the users to other forms. On first load on first use on first day there is some data that needs collecting and should never be needed again. I thought it would be a simple matter of telling my master switch that on load to hide itself and...

I have time base events occuring in some of my access programs. They do require access to be open at the time, however, I instruct my users to leave them open. My work around is: Set up a form called frmTime this has a caption box, which displays Now(). In the on timer event is where the...

From time to time, I have wanted to post word documents into access. If the document is static and does not change I have had success by copying and pasting into a label box on a form. I then create this as a sub - form and give my user some control over the subform by scrolling.

I did try setting the focus to the control on the form, and it still does not seem to respond like I thought it would. I think the switchboard is continuing to load post the code, and I think this is the problem. So in essence, for a millisecond or less the form has focus, however, the...

My application has a master switchboard, for directing the users to other forms. On first load on first use on first day there is some data that needs collecting and should never be needed again. I thought it would be a simple matter of telling my master switch that on load to hide itself and...

Thanks for the replies I will try your suggestions.

I think your code should read: DoCmd.OpenForm "invoice", acNormal, , "f_outstanding invoices", acFormEdit, acWindowNormal

I have been asked to add a timeclock function to my forms. I had a look at a few books and have only found a reference to a timer control in VB 6.0 which does not appear to be available in VBA. I need the timeclock to run continuously regardless of events or non events on screen and when a...

Thanks Mike, but I haven't started integrating solutions across packages yet. Excel would seem an ideal way to go from what I understand. I don't know what to do to make this automate though.

I have several tables I want to place on one computer, these are to be updated by the operator and then emailed to me. I know how to make the email occur okay from their end. My question is which format is best to use rtf,html etc and how do I then get them back into my access data base at...

From what you have typed it would appear the .value is upsetting the applecart. Try: DoComd.FindRecord foobox,etc I reckun this'll fix it.

I am sure this is really simple, however, as often happens I just don't get it. I have a field called cal which is updated by the user at random intervals based on the previous input. Now what I need to do, is find the value of the last entry, which could be anywhere. For this I use: varC =...

Look all you genius' I don;t get this, but I think it is the solution I am after. I will try and explain what I am trying to do. I have a table, for simplicity we will call this table1. In this table are several fields which hold various items of information which are called by my main...

I am trying to run the following code in a case select BeforeUpdate. I keep getting an error mewssage saying I must save the record before I do this. I thought this modified the record before it was saved. I am confused. strA = InputBox("Free Available Chlorine appears to be high. Please retest...

The control before update