Microsoft Access / VBA Forum

Allen, or others, In my tables there is a unique key that identifies each new company record with a number, this variable is Company_ID as has been typed up in the edit table data view. Thus I think you are referring to this unique new identification number that is created from my AddNewCompany form, thus that can be used to open the new...

Hello all, As usual I've managed to copy a function I found on the Internet into my application and get it to partially work. The problem is that when Access encounters a field which is empty, it gives me the message "invalid use of null"-- for example, if the FirstLastName field is empty for a record.... Can someone please tell me what I...

What is required before you have the MS Access upgrade, or the Office pro upgrade? Thanks

Greetings, Hope someone can HELP! I was running Access 2K - SP1 and on a whim went to the MS Office update site and upgraded Office2K to everything current, SP3 and whatever else it recommended. When I went to a mdb to open it up - BLAM - it had my Network Username prefilled in the 'Name' field (which doesn't really mean much since I...

I want to have a command button which enables the user to make a copy of the current database, but without any records in it. Of course all the forms and reports will be intact. I want the old database to be given a different name so that it will be obvious that it is an archive copy and so that the new empty database will continue with the...

Thank you, Wayne, for your answer. That was exactly what I needed. There was tiny mistake strSQL statement (Table1.* should be tblHello.* ). To answer your question why I need this. I have table in accounting program and in order to track changes in the VAT, I have made queries which would track these changes. I had to only indicate which...

I am having trouble running queries. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What am I doing wrong?

I have a database that lists orders and there required delivery date, 10 days prior to that they have to be actioned is there a way Can have it remind me in similar way to Outlook with an automatic pop up with sound. Regards Lewy -- Message posted via http://www.accessmonster.com

I've a database in VFP 6.0 which I converted to Excel format and then to MS Access 2003 format. Now its not accessible through ASP. If I convert this one to prior MS Access version, ASP script will work, as I've tried it with other MS Access databases.. can anyone pl help???

Hi all A quick question which I've not been able to solve from trawling the web. Is it possible to have a control in the detail section of a form set to a default view of "Continuous" which only appears on the last record? I'm thinking of having a form with a subform, and would like the

Is there a book or website that covers the topic of getting a barcode reader to work with Access? One thing I'd like to do is scan a barcode with the Main Switchboard displayed, and have the program bring up the associated transaction record. My wand/keyboard wedge "types" in the stored value plus an Enter at the end. Lee

I have to create a database of products and i need to do it by reading the HTML to derive fields. I did this fine, but their are so many other pages within each category, for example: the next page button will take you to the next pages etc etc. Does anybody know a way I can follow these links and read the html? Thakns in advance

I have field with many numbers and I wish to make by code another number which is bigger than the highest number already in field by one. I do not wish to use the autonumber. Can anyone help.

I am currently using a form to track employee time to customer and warehouse. I want to be able to take information from one record and post this to tne next record(finish time on the first record to the start time on the next record)as well as employee name etc: any ideas?? -- Message posted via http://www.accessmonster.com

oops. Forgot to mention... Particular stumbling point is how to create a form in 'datasheet' view that includes a subdatasheet. --- Dale Walker London Techno Events dale@sorted,org http://london.sorted.org

Please help!! I have a form and in it are several subforms. In order for users to move from the main form to the subforms there are tabs on the upper part of the form. I have one field that when data is entered on the main form, I would like that same data to move to the same field on the next subform. How do I do this?? Any suggestions...

Most likely a very basic, boring question! My new computer has WinXP (old one Win98). I have installed Office 97 and all is well EXCEPT the Access program. It will not allow me to "Get External Data" from any directory on the machine. The drop down "File Type" window has limited types. There is always a message that I do not have...

Hi, I'm not sure if I'm in the right place, but I need a program (or to write one) that will allow me to assign a specific color to a given numerical value. I have a numerical data set that I want to represent by colored boxes--kind of like how meterologists show you the temperature on a colored scale. Can I do this using HTML? I'm just...

Dear all, My interface run on a computer in a public place. People can add there contactdata in a database to receive information about a company in the future. The user has a unbound maximized modal form to add his contactdata by pressing a cmd-button 'Add this contactdata'. To exit the interface you have to click the Quit-button and...

Testing...

I want to remove all white spaces from the beginning and end of the string. I am using the following SQL code: SELECT TRIM(' Sample '); I am supposed to receive the following Result: 'Sample'

Hello: I have a database (Access 2000) I need to use under CHinese Windows 98. I have used chinese fonts in True Type SimSun and I also have CHinese Star which I can use for the Chinese fonts. I'm trying to get a computer where I can install chinese windows to test the database before it goes to the users, but I don't know if this will be...

Hi, I have some more complicated things (for me) that I want to do in an Access survey database. I'm totally new to VBA-syntax and I don't have time to dig into it to much. I would appreciate any advice on the following things that I want to do: 1. Run an external Java-progam with control of that it must be ready before executing more...

I am the beginner of all beginners in Visual Basic.Net 2003. I'm looking for two types of books. One specifically directed towards beginners and one that shows examples of code for different types of applications. Especially code that shows you how to do most of the processing on the SQL Server to enhance speed of the application. Any...

I'm hoping someone can tell me if I'm doing the correct thing here or if there is a better way to do this with Access2K connecting to SQL Server 2K: Dim myConn As String myConn = "PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=myCatagolName;DATA SOURCE=myServerName;Network=DBMSSOCN"...