Search results for query: *

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...

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...

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, 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...

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...

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...

Hi, ive got an sql string that works fine. The sql string is generated in an afterupdate even of a list box in VB. Im having a bit of trouble getting it from the form to the report (string name is Reportsql, and report name is rptRemitance). i think its to do with it being global? But when i...

I hate running to the form every time i get stuck, but ive been thinking how to do this and im completly mythed! I have a list box, lstMonthYear. It takes data from tblPurchaseInvoice, groups Date, and formats the date and fills the list box, eg, List box shows: January 2003 March 2003 June...

Hello. I have a set of records in tblPurchaseInvoice I want to fill a list box on a form with dates that are in this table, and change the format, eg.. tblPurchaseInvoice.Date 01/01/03 01/01/03 02/01/03 05/01/03 01/02/03 01/02/03 04/03/03 04/03/03 01/06/03 01/03/03 Listbox displays: January...

Very noobie question here, ive been searching google and this forum for ages but cant find an answer to this amazingly simple problem, I know it can be done from a switchboard/front end menu. I just want a basic input form, that when is opend will be in add mode only, and not show any...

Hi, I have a piece of code, ive tried in the after update/lost focus event of a txt box, and ive made it into a function and called it in the update/lost focus event of the txt box, however, the setfocus property just isn’t working at all. Dim strCriteria As String 'search tblsupplier.shortname...

Hi, im trying to make a record set that searched a field in a table, if the data thats enterd into a text box on a form, it returns a message saying so, ive been reading around a lot and trying different things, this is what i have so far Dim rst As ADODB.Recordset Dim strSQL As String Dim...

Hi I have a table, tblSupplier, and a form frmPurchaseInvoice, there are two text boxes on the form, txtSupplierShortName and txtSupplierFullname. When the user types in the short name, i want the second txt box to fill with the full name found in tblSupplier. Im guessing the best way of...

Apologies for the length of the post first . This is actually spurring off another one of my threads. I cant find a solution to this problem, nor can I see what the problem is, its been bugging me for a bout 3 weeks on and off now, any help would be greatly appreciated. I have three tables...

i know what i want to do, i just dont know how :) basically i am making a statment report for an accounts database. I want to do an aged analysis on the statment. for instance, it totals up what the customer owes current, 30, 60, 90 and "over" days. If the invoice date is in the...

Hi, just a quick question. Ive made a report, and ive put in a total txt box, and in the expression builder for that txt box ive put a calculation...

Hi, Ok, i know there has to be a way of doing it, but i really cant work it out, i been trying all night. Basically i have 12 check boxes on a form, January to December. I want to create a query, which a report will use to print out entries from a table, depending on what check boxes are...

hi, i want to query a ms access database from a vb program, im using MS Visual Basic 6. Idealy i want to end up with the database file and an exe. The database is called dbPartsList.mdb and contains one table (tblPartsList) i have created a text box and two lables on the vb form (txtInput...