Search results for query: *

Problem solved - turns out i needed the latest FCS update to stream the higher quality.

Hi, I have a very simple flash program, which takes a video stream from a webcam, and publishes it to a Flash Communication Server. I then have a viewer program, that taks that stream and shows it on a web page. It all works fine, apart from one thing. If i add the following code to the...

Hi, that sounds like just what im after, problem is i havent got a clue how to use it? Never had any experience with WMI before, i couldnt even tell you how to implement it. Could you give any more info? How would it work, would the internet traffic still be sent to the windows server, and...

Hey, hopefully a simple question: At my office we have two gateways, a 4 line ADSL solution providing 4mbps down, and 1mbps up, this is our primary connection, but is prone to downtime, sometimes for a minute, sometimes for an hour. We then have a backup connection, which is slow, but is...

Hi, im trying to set up a VPN server, which will allow individual remote clients to connect to a small office LAN of 3 workstations and a server running window server 2k3. I have only started using server2k3 2 days ago, but am learning fast. And this is the first time ive set up a VPN too...

Thanks mate that worked a treat! Cheers, Elliot.

Hi, I have a simple input form with a date field. I use an SQ INSERT statment in VB code, which takes the information from the form, and saves it to a table. The database is split into front end / back end. When a user inputs a date in UK format (im in the UK), eg 01/05/03 (dd/mm/yy), once...

Hello. Ive been trying to put a running sum on a subform, ive searched around quite a bit and found dsum is used quite frequently. My subform is based on a query, names: sfrmTransaction, qryTransaction, frmTransaction. Fields: Amount, TransactionID. Where is the dsum expression best to go...

Hi, sorry for the very very late reply, but i put this on the back burner for a while as ive been doing other things. Ive checked out the runningsum in access help and on this forum, but it seems its only used in reports, and wont work on a sub form in datasheet view? Ive had an experiment but...

Hi, Ive got a sub form (datasheet), the subform is based on a query. It has various fields, one of which is amount. I want to create an Accumulative total field, which takes the record and adds it to the ones above etc. The scenario is a bank register, so the user can see what transactions...

Apologies for late reply! That worked a treat, i thought it was something like that but i couldnt work it out. Many thanks.

Hi, Im not sure if I have the terminology correct, but heres the situation. I have a list box on a form, when the user selects dates in the list box, the after update event creates part of an sql string, and adds it on, known as MonthSql. The sql output looks something like this: 01/01/03 OR...

Great stuff, thanks again! Works a treat.

Brilliant, i thought it was something like that! Thanks! Instead of starting a new thread, i got another simple question, may as well add it on Whats the code to run a query from vb, i have Call DoCmd.OpenQuery("qryPaidUpdate", acViewNormal, acReadOnly) This runs fine but i get...

Sorry forgot to change, "frmPurchaseInvoice" was the name of the form i was using to test the command, you should put the name of the form you want to open up instead.

In the "Add" buttons on click event, this VB code will open the form in add mode: 'Call DoCmd.OpenForm("frmPurchaseInvoice", acNormal, , , acFormAdd) This will open it in edit mode: Call DoCmd.OpenForm("frmPurchaseInvoice", acNormal, , , acFormEdit) If you play...

Hmm could have sworn i put a thread title in, oh well :)

Hi, i have a sub form, which shows invoices for a particular customer, there is an "xselect" on the subform so the user can select what records they want to delete etc. Ive created a bit of code that sums the total amount of all of the invoices selected, and am trying to use a record...

Also, is there a property to see if a query exists? eg IF qryRemitance exists then db.QueryDefs.Delete "qryRemitance" else Set qdUserQuery = db.CreateQueryDef("qryRemitance", ReportSql) Thanks elliot.

Thanks! I used the dao version steve gave me - it was the simplest to understand! Thanks for answering one of my threads again tek head too! Any ideas on the other question? how can i change the contents of a txt box on one form from a sub form after update event? I keep getting the error...