Microsoft Access / VBA Forum

Greetings, In Access 2000, I have a select query where I need to write an expression that will look at a text field and return the third character. (This will be used later in a report based on this query to create subtotals.) In Excel I'd just use the Mid() function -- =Mid(, 3,1) -- but this is a worksheet function and can't be used in...

I hope someone can help me get this graph outputing in proper order. After help from Tom, I got a graph to display output from the previous 12 months and include the average of that output all in the one graph. The output was in the order of the months, but after unioning with the averages SQL code, the order is lost. Below is the full sql...

Hi I have an A97 client attached to an A97 backend both located on a server. The users can download the client to their PCs. I disabled special keys on the copy on the server so they can't use F11 etc I also removed Tools from the menu. When the user copies the client locally, I found the special keys are enabled. Is there a way of keeping...

Hi I am building a simple database system in MS Access 2002 and would like to create a command button that upon clicking transfers the current mdb-file to an ftp-server. Is there a solution for this in MS Access 2002 or do you have any other suggestions to solve this issue? // Mattias

Hi Does anyone have an example of using the Internet Transfer Control from behind a proxy server on port 8080? Thanks Regards

Hi all, I have a table with numerical information in it (scientific notation) and a simple report that displays this information relevant to a query on the data. My question - Some of the data has a valid zero value. Is it possible to make the report NOT display the zero value and only the cells that contain a whole number?

I've got a small database that I use to track my golf scores. It's got 2 tables, Courses and Round Details. The Courses table contains the names of all the courses I play and the Round Details table contains info on each round of golf I play. When I want to enter data from a new round, I use a form, which I'll call "RoundData", and in this...

Hi. I'm not a SQL power user but can handle most simple queries. But I have no idea how to approach this problem...hopefully someone can point me in the right direction. I have a table which lists point numbers, bird species that was seen at each point, and the number of birds seen. So, if I saw 5 different kinds of birds at point #1, then...

I have a form where records are entered. I have turned off the built in record control. I created buttons to advance and go back through the records as well as an add new record button, but I also want to display the current record number. I have a blank control on the form to display the number but I can not figure out how to assign it to...

hi y'all! i want to implement a few macros to help me do my coding; when calling a macro: how i can i find out in which module i'm currently in; at which position and what text i have selected. it's gotta be possible somehow, but the screen-objekt really isn't of much help. can anyone help me? thanks in advance! mike maercker

This code is behind a button that exports the contents of a query ("qryXL_Tx") to an Excel spreadsheet. It works fine the first time, but will not run a second time. When I go to look at my query... it's blank! No SQL at all.... Any ideas why this sub is eating my query?? Private Sub cmdExportXL_Click() strXLfile = "Transactions_" &...

I'm having difficulty converting form 97 to 2000. Tables take forever to open in design mode (queries, too). I have heard that if I build form scratch instead of convert that the problem goes away. Anybody figure this one out?

Okay, I have a query that generates a list of ClientID's that I want included in a count. Take a look at the following query and make any changes that you see fit to make it operational. SELECT .MaritalStatusID, Count(.MaritalStatusID) AS CountOfMaritalStatusID FROM GROUP BY .MaritalStatusID HAVING MaritalStatusID <> null AND

I would like to setup a form that will log the users logging in to a db. The form and the Db will currently log the users if they complete the logon and get in. It will then log the entry, but not if they fail to login. If they fail I would like it to log the attempted pass and the computer name from where they are logging in, the systems...

Hello, I'm using A2K and would like to update our school back-end server file. I've taken a copy of it home because I was having some trouble updating it at school. I basically want to add 30 some odd names to the end of a student list. Can someone please tell me the steps that I should follow?

I have a button on a form that opens a report. I need to set the caption of several labels on the report equal to the value of a columns in comboboxes on the form something like: LabelOnReport.Caption = ComboboxOnForm(2) Where the boundcolumn of the combobox is 1. I keep getting an error message no matter what I try. How is this done?

Hi, I'm trying to make a calculated text field in a query where the textvalue is being populated from multiple records. I already use a VBA function to loop through records and concatenate the text. It works but the performance is really bad. I'm looking for a solution in plane SQL, so the looping is done by joining tables. I can't get it...

I have a query with a date field criteria of: Between And When the query is run, I am asked for the Start date and then the End Date. So far, so good. The records returned are all those in between those dates and not records that are on the start or the end date. For example, I enter "09/01/03" for the start date and "09/30/03" for

Hi, i'm sorry for my bad english but ..i'm italian.. I have a big problem that I don't succeed in resolving on the command sendobjet. I have a query that as resulted a list of addresses e-mail it furnishes me with send object I would like to automatically send a mail to all you address him present in the query.. as I can do?? I use outlook...

I remember that I used to set up utility batch files, and create Windows shortcuts to them that would ask the user for parameters to supply to the batch files. From what I can tell, this functionality simply doesn't exist anymore in Windows 2000 or above. I did find a work-around to this that I thought y'all might want to know about. ...

I want to give the user the ability to change a setting. Example Discount rate = .4 value stored in record 1 tblSettings.Discount the user will be able to change the value through a form that only allows modifying record 1. How do I pass this value to a module and then refer to it in queries,

Software: Office XP Systeem: Win 2000 I'v been trying to merge an access database OLE field (containing RTF text) into a word doc. The mail merge works OK, all database fields are added except the OLE field which is displayed as "Long binnary value or text" in the word doc after the merge.

Over the last year I have designed a database to store information in the school I work in. It has now replaced the commercially produced programme we were using. I should like to market this and make it available to other schools. I have done some research and noticed I would need Access developers toolkit. Could anybody tell me if this is...

Yes, I've downloaded and read the white paper (though some time ago). I was considering an alternative to the built-in Access security. Having more than one FE file. For instance there are a few maintenance forms (for adding/editing a few lookup tables) which I only really want the office administrator to have access to. Other forms I may...

Hi all, I have a web site which allows our customers to write data via forms into an access table stored on our ISP's remote server. My question is how do I efficiently retrieve the data? ISP tells me I am only allowed access to the web site via Frontpage. Even if I could set up a linked table from my desktop PC I understand that...