Search results for query: *

Hello, Need help fixing a looping issue, and a few others. First off I'm new to VB, After searching for vb sample of FlexGrid with amortization schedule I had no luck. I found a sample that outputted the data to excel so I starting playing around with it, after finding a few links on how to use...

Create a new Access Database using VB. I have 2 procedures. One creates a new Access .mdb file. The next sub creates the tables. My question is how do I set/format booleen valued properties to a checkbox. During execution it creates a Textbox! Next issue is formatting a valuelist, and...

Please Help.... When asked if I could do this, I found the PMT worksheet function in excel and thought it was a no brainer... What am I doing wrong.... Here is the formula I'm using, straight from ms help. =PMT(C3,C4,C5) Calculates the payment for a loan based on constant payments and a...

Hello, I'm trying to diagnose a small network issue of 5 computers running Win XP Pro. An employee setup the 5th PC! So I'm aware what they have done! Here is the senerio--- PC -(1) - Acts a file server. That has the C drive shared. It's been in place and working fine for 2 computers that...

Dim p As Property Dim db As DAO.Database Set db = CurrentDb() 'set the required expiry date (defaults to 30 days from now) On Error Resume Next With db 'check to see if already defined Set p = .Properties("myCompany") If Err = 3270 Then Set p...

Hello All... I know have seen a function out here that does this, but after several different search senerio's I could locate it. Basically... I need to loop or read a text file until a specified point. Save that position. Process what I've read... Write it to a tmp.txt file for import...

Hello All... I must have over 40 different sample files I've download from various sites, or created from example code! They all work... To some point... BUT None of them has successfully uploaded a file that was larger than 200MB in size twice in a row!!! If that, if I was lucky. 1st file...

Hello All, I have a form the uploads files using FTP... The file sizes average about 300MB! If I minimize the form, or the screensaver kicks in, when I restore the form or return from the screensaver, the form is completely white! If tried setting a booloean value to test if an upload is in...

Hello All, I have a spreadsheet that gathers data from several other worksheets. The last worksheet is suppose to display, Total Cases Needed, and the remaining partials if any... worksheet layout: Row of Qty per case. 12 columns(Items) Next Row: Line Item Totals(per item) from 4 different...

Hello all, I have report that displays the top 6 records, generated from a query. I added an unbound label to the report called: lblPlace I want the label to display: 1st, 2nd, 3rd...6th Here is what a have so far, but it's printing 6th Place for every label... How do I get this to work on a...

Hello All, I have a vb app that does several things before rarring an .mdb file that is copied to a web server. I need to check the dbs.Properties("StartupForm") and make sure it was set to the frm_Register and if not, change the startup property to "frmSecure" then display the database so the...

Hello, I was wondering if it's possible to get the date created and date modified of files on an FTP server using FTP and put them into an array. Then I'd like to compare the date with date of the file(s) on the users PC, if the dates don't match, then list the files and allow them to download...

Hello, How can I keep only 2 or 3 of the most recent files, and delete the rest. I have an .mdb file ToolingFE.mdb(developers copy) Which is copied to user folders when ever he makes code or form changes. If the file is not in use, it renames the file to the current date, removing the '/' and...

Hello, Is it possible to create a vb script file to copy an .mdb file to every sub-folder from it's root folder if the sub-folder doesn't have a .ldb file and rename the previous file so that it doesn't get over-written. Example: Server Folder //K/Access/MDB/ Then in the MDB folder... There...

Hello All, I have a database I want to split into frontend/backend. I want to have the backend database at a website like: www.yoursite.com\client\dbs The frontend database has a client table and a login table(linked to backend) The user adds a client, and issues a login for them which is...

Hello All, New to VB - I'm trying to convert an MS Access application into a VB front-end with an access back-end, Working with ADO controls. How do I program the cancel button so that the user can click it to 'not' save his edits or new record data and return the record to it's prior...

Hello All, I have a form with 6 text boxes, Each textbox requires 6 characters with the exception of the last using only 2. The form is used to lookup or generate a help desk call. The user is prompted with the 32 digit error code which he must give to the operator. I've broken this up into 6...

Hello All, Few questions regarding installing a new application in a corporate environment! 1. Questions regarding Registry Entries... I've created an application, that on setup(during install process) it creates an entry in the HKCU\Software section of the registry along with a few other keys...

Hello All, From within access, I'd like to open a db on the internet, find a record based on the customer id, and update it with thier table version (a string value) and return true if it succeeded! Is this possible from within access? If not... Can I read/write cookies from access? I would...

What I'm attempting to do is have the user enter their name, company name and the registration key when starting the program... The reg key is a unique key based on user name and company. Here's where I need some direction... When we store the user name and company name! I'd like to generate...