Microsoft Access / VBA Forum

Thank you in advance for any and all assistance. I would like to know how I can close out a Query/Table and Create a Table with the year? I want to be able to create a table with saved data and name it for the year that is current, or the previous year, should I close out the end of year, after January 1. Michael

cmdButton to Print 3 copies of record in Form view ? cmdButton will print 1 but I need 3 copies of the one Form record. -- Dave Allison

I have another question for the community, and hopefully it's an easy one. It seems ridiculously simple, but I can't find anything on it. I have a combo box that is bound to a table. When a form is opened, I'd like the current value of said combo box to be dictated by a value given by the previous form. For the life of me, I can't figure...

Can anyone point me in the direction of a sample Access booking system? Trying to build a booking system were customers can book a computer by date and timeslot, each timeslot having a limited amount of computers. Cheers for anyhelp, pointers given. PaulD

How can I connect to my online database? I have all the paths etc... I can't even think where to begin, what would be great would be a front end on my PC connected via ftp to my backend at my ISP. Or is this just ridiculous and impossible?? Jon

Hi, I'm pretty new too Access 2000 and I have a database that I with the details of peoples names, i.e. surname, forename, ref number. I have another table with surname, forename, etc plus some other details, including videos. For arguments sake, the first person is a parent, the second is the child, and the videos belong to the child. The...

Ok, here's a strange one... I'm using a lot of Followhyperlink code in my MS Access2000 application to launch various websites. All my forms are popup, so they run outside the MS Access window which I keep shrunk. When a user launches a website through the Followhyperlink, the website opens fine. If the user closes the window, Access returns...

In an openform event if I type cancel=true a msgbox pops up saying: "The OpenForm Acion was cancelled" This is iritating. Is there any way to turn of this message via VBA? Thx & Best Rgds, Prakash.

Please can anyone tell me how I can create a macro to save the results of a query as an excel file? The query is called Student List and I would like to save it to "My Documents". We have had some problems with our database crashing. We would therefore like another way to have access to basic student data and thought we automatically save...

I hope someone can help with this. I have a website using Access and ASP developed on my own PC (using PWS) and hosted on a commercial site. I decided that splitting the dbase up would be a good management tactic; it si easy to link from the main database and it works fine - on my own machine. Trouble is when I upload to the commercial...

I have a buch of fields that I'd like to update on a form at once, but I'm having a problem with allowing fields to be blank. If any of the fields in the SQL statement are blank, the update doesn't work. The way I see it, for example, SET ContactLastName='' (two single quotes) is somehow invalidating the update, although I can't seem to...

After rebuilding my Win2K computer and installing MS Office premium 2K edition I cannot install the VBA tools from the ODE tools CD. When I start the installation I get a message saying that I should install a program that uses VBA first and, if I continue, the option to install the VBA tools is greyed out. I have Access 2K running and VBA...

Hi all I'm in the process of upgrading a job from .mdb to .adp->msde & am reconsidering some aspects of the design of me schema while I'm at it. One of the tasks of this job is to schedule the loading and unloading of trucks. For this the scheduler needs to see the load on the truck, before and after loading, i.e. Opening Load + Variation...

Hi, One of my users are getting a message "You copied a large amount of data onto the Clipboard." in Access 2002 when closing the database. I haven't made any changes to the database and they are not copying any data from the tables. I can have up to 3 users working with the single file mdb concurrently using shortcuts (I haven't split the...

I have a data application in a2k that I need to create two fixed width text files and then combine them to a single file The first file is header information and the second is transaction data. I have tried and tried but just cant seem to get this right, I am using Queries to created my export files with specifications which works fine, I...

I'm attempting to build a module that will allow me to update one field of a record (using a value from a previous record) based on the value of another field in the same record. I can successfully "cycle" through the records one at a time and get to the appropriate field as well, but any attempt to read the field values (using SELECT, of...

Can anyone help. I have an access database with a couple of thousand records in it ... :shock: problem is i need to type one of the fields values into a data entry window for another application putting an enter between each record ... e.g. In Access (data from a query)

I've build a small database for my swimmingclub. It consists of 4 tables: participants (e.g. participant 1, 2, 3 etc.) competitions (e.g. swimming contest 1, 2, 3 etc.) programs (e.g. 100m breaststroke, 200m butterfly) times (participant 1 - swimming contest 1 - 100m breaststroke - 1.23,2 participant 2 - swimming contest 1 - 50m butterfly...

Right... Using a cross-tab query I now have a way of getting the data in the form I want it -(thanks for that Scott!), only thing now is that I can't find a suitable way of making it into a report....I Can get a report but if I then add more dates they arn't shown in the report, only the ones that were in the database when the report was...

My company has this old damaged database that we seldom need to use. Nobody wants to put the time to fix it and convert it, so it's still in Access95 format. I recently upgraded my Catia CAD workstation to 2GB RAM and suddenly I get the dreaded "Out of Memory" errors when trying to open Access95. I've tried running in compatibility mode and...

Hi everyone! In Access 97, I have a parent form and a subform that are both based on the same query. The main form is continuous and serves up a summary for each record. The subform provides details on the record and is linked to the parent record via an autonumber ID. My users want to be able to add new records to the table underlying...

Hi, I have a table containing analyst information, and each analyst has a unique ID (30 analysts, analyst IDs are 1,2,3,...29,30). I am creating a search form which feeds an underlying query with the search parameters, and returns the results in a subform. I have used a SELECT query to populate the "ComboAnalyst" combo box, and have...

Hallo! Frage 1: Ich habe kürzlich eine Access Datei von 2002 auf 2000-Format konvertiert, da auf dem Rechner in unserer Arbeit nur Access 2000 installiert ist - gleich ist ein kleines Problemchen aufgetreten (eigentlich mehrere, nur dieses hier hab ich nicht lösen können). In der 2002-Datei funktioniert diese Sub-Prozedur reibungslos: ...

Below is a query that I currently have. I need to produce a subquery so that the top five of the CodeCount is returned. I appreciate your help. SELECT .PX_SURGEON, .PX_CODE, Count(.PX_CODE) AS CodeCount, .PX_TITLE FROM INNER JOIN ON .PX_CODE = .PX_CODE GROUP BY .PX_SURGEON, .PX_CODE, .PX_TITLE ORDER BY .PX_SURGEON, Count(.PX_CODE)

Hi Experts, I'm working on Win2k platform, where a process is wrinting to a log (plain text in tabular form) . My goal is to view this grawing log on access database, I linked a