Microsoft Access / VBA Forum

I've been developing and selling Access based database products for years, and this group has always been a great resource to me. Now I find myself releasing a new Active-X based on some of my code that I've been using for years; and I would like to know what the group thinks of the idea... I have put together a ocx control that allows...

I have an unbound combobox in the form header of a continuous form. The selection in the combobox sets the where clause in a querydef which determines QryPFrmInventoryManagement. The following code is in the afterupdate event of the combobox: Me.RecordSource = "QryPFrmInventoryManagement" Me!ItemCount = Me.RecordsetClone.RecordCount & "...

Hi, I have two columns in my Bookings table of type DATETIME - Booking_Start_Date and Boking_End_Date. How can i update every row so that all of the times for Booking_Start_Date are 09.00 and all of the times for Booking_End_Date are 17.30, without affecting any of the dates? Thanks for your help

I'm trying to put a function into a query. I want to check the logical field "closed." If it's true, I want to return a text value of "Closed". If false, I want to return a text value of "Not Yet." Here's the value in the query: Expr1: IF(,"Closed","Not Yet") It accepts it without an error message, but when I try to display it I get...

I'd love to hear some expert opinion on my situation. My department relies on Excel as a database, which causes crashing due to resource depleting and basically is just too slow. For example, a user must open seven Excel workbooks so that each can lookup values in the other to rollover into a separate "summary" workbook. Obvious problems...

Hi I have a database that I would like to be able to compact when the exit button on the main form is clicked. Can anyone help with this? TIA Colin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

Can someone tell me how I would delete all rows but one when both records (in a two column setup) are duplicates? For example: NAME | AGE BOB | 23 BOB | 23 BOB | 23 BOB | 25 BOB | 25

Greetings again: The database we are using at the office here has an Access 2002 front end (client) on each user's work station. The data tables are stored on the server located elsewhere in our office. Each client links to the tables on that server allowing shared access by the 25 users we have here. Is there a way to have the queries run...

On Thu, 2 Oct 2003, "Gary Floam" <floam@comcast.net> wrote: >Sure you can do that. The easies way is to create a table of the last names >selected, and join that table into the query definition. > >If you write your own SQL, you can create a string something like > where LastName in ("Smith", "Jones", "Brown") > >Good luck >

I'm working on a calendar-program. I wonder what the best approach would be for storing the begin- and end date/time for a particular calendaritem. Right now I have two fields: Startdate and Enddate. Both date/time. This is giving me terrible headaches when trying to let the user edit time-part. Let's say startdate is '01/01/2003 22u15'. When...

Hi, I have a table with a field "signiture" that is set with a data type of "OLE Object". If I view the table (in datasheet view) and right click on the relevent cell I can "insert object" which then allows me to link from an existing file. What I want to be able to do is to get to the "insert object" part from a Form. Any ideas on how...

After installing a few security updates yesterday, I was surprised to discover that none of my MS Access applications work today. After doing some research, I have discovered that when the DAO TableDef.Attributes property is set to dbAttachSavePWD, I now get an "Invalid Argument" error where I did not before. My theory is that one of the...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

Hi, I have a printer consumables database. I have a form designed to change the status of consumables ie. in use, dead, stock etc. I select one of my consumables records from the combo box and it displays the current 'status' field in a 2nd combo box. I can then select from the status table (ie in use, dead etc) but i need to take that...

I have written a procedure which calls the CORREL function of Excel to run correlation analysis on two arrays, then populate a table with the resulting correlation coefficient. This process loops through several records and recordsets. The procedure works well for awhile (sometimes upwards of 10,000 times!), but then mysteriously begins...

I have a linked bitmap as the background in a subreport. If I run the subreport by itself, the bitmap appears. If I run the full report, the subreport appears but without the background. If this the way it is suppose to work, or is their a trick I am missing? Using Access 97. Thanks, Norman B. Scheinin F-22 Applications Development

I am trying to diagnose a rather insidious problem. Yesterday, I tried to install the .NET Framework 1.1. That installation failed. No big deal -- I can live without it. Now, however, none of my MS Access applications work. I've researched the problem and found that whenever the DAO TableDefs.Append method is executed in code, I get...

Greetings, In Access 97 I have a subreport with two labels and a control. The record source for the control is a simple SQL query referring to another query: SELECT DISTINCTROW qryInitPositions.PortfolioNum, qryInitPositions. FROM qryInitPositions;

Microsoft Access help says the maximum number of Modules, Forms, and Reports is 1000. It appears that linked tables do not count. What about local tables? Help also says that the maximum number of open tables is 2048 (or less). That would seem to leave linked tables out of the above mix. Can anyone comment on these limits or quote...

Hello everyone! I'm building a form in Access 97 and I want to to show a special icon if the record has been marked as deleted. Obviously, I don't want the icon to show if the record was not marked as deleted. I understand the conditional formatting is available in Access 2000 for this purpose, but it is not in 97. Is there a way to...

I've got several access databases that are missing passwords and am decrypting them using the following algorithm. I am running into problems translating some of the missing items. It looks like some of the information is stored as ASCII or EBCIDIC, but cannot determine what the missing HEX codes mean. Anyone have any clues? Zack ...

How can I print the database structure, including non default variables like Requiered, FieldSize, and most important DESCRIPTION. I want a table like this: ----------------------------------------------- | Name | Type | Size | Required | Description | ----------------------------------------------- | ... | ... | ... | ... | ... ...

I am producing a report that requires me, among many other things, to calculate the average contracts for about 1000 companies during the yr 2003. The "quirk" is that all the companies do not have the same number of months. When using DB2 the below code counts the average contracts of each group for 2003. What code can I use in MS ACCESS to...

Hi! The following code give me an error message (syntax error 3075) and I can't figure out what is wrong! Any suggestions? Sigurd Dim stDocName As String stDocName = "rptFaktura" Dim stLinkCriteria As String stLinkCriteria = "= " & Date

I have a main form with 4 subforms. One of the subforms reflects other costs/miscellaneous charges that an account might be assessed. The main form includes a field with a total pulled from that other cost subform. The total field reflects the correct amount as long as there is at least one record for the account in the other cost subform. ...