Microsoft Access / VBA Forum

A process presents frmSecond for user entry; user closes when done. Code for opening the form is DoCmd.OpenForm "frmSecond", acNormal, , strWHERE, , acDialog Problem: frmSecond does not remain on the screen. Instead, it shows again after the process calling it has completed. Can anyone tell me what might be causing it to "hide" itself until the process completes? Thanks for any help. L Mehl

Hi I created a simply database and I created a form to enter the data. But I will like to create a button that brings a window where it ask me what specific record I'm looking for. Does somebody knows what code should I used so I can search my record more easer. Any help I would really appreciate it. Thanks, Evelyn

Sorry about the dup post, somehow my original post was put on an existing thread instead of a new one. Access 2000 I am working with a service call database and would like to create a query that looks for repeat trips within a user defined time period in minutes. The affected fields are CustID, CallDate, TimeComplete, TimeReceived The result would show all calls that a return trip was made within 60 (user entered) minutes within a specified data range. A return trip is a separate record so we are comparing timereceived and timecomplete between 2 records. Any and ALL help truly appreciated! Dale

How do I calculated a number and store it in a table? Thanks Won Mee

After installing Access 2000 runtime on a PC, when opening an Access database will it automatically open using the installed runtime or does the runtime need to be reference through the database somehow? Please advice. Thanks in advance. Dawn Davis

Howdy, I need a query that will find all duplicate records and display them. For example, I have an ID an email field. I want access to track down records with the same e-mail, then give me the ID for each one. How do I go this? Tal.

I would like to query a database for 3 children whose fathers are the oldest. The answer isn't necessarily unique: if the oldest father has 6 kids, then any three of his children will do. My first shot was: SELECT TOP 3 NAME FROM KID, DAD WHERE KID.FATHER=DAD.ID ORDER BY DAD.BIRTHDATE However, in the above example this yields at least 6 children, as the top 3 birth dates cover at least the 6 children of the oldest father. My second attempt was to have the order-by clause enforce distinct rows by adding a primary key: SELECT TOP 3 NAME FROM KID, DAD WHERE KID.FATHER=DAD.ID ORDER BY DAD.BIRTHDATE, DAD.ID This works, although it is a bit slow, due to the double sort. However, it looks a bit clumsy: is there a better, standard, solution? Also, when I incorporate this in my Java application, as opposed to running it as a small test, query performance drops by a factor 50. It is the one query I haven't been able to incorporate successfully in my code, and I suspect I hit some special case of resources becoming scarce. I checked and double checked that I'm closing ResultSets, Statements and Connections everywhere, I tried to use a new Connection for this one query, but it didn't make a difference. Are there any known issues with horrible performance drops in jdbc? -- Grinnikend door het leven...

Public Sub ShipmentRequest_Click() I am trying to be able to access records from another database table, from the one that I am currently in. This is the code that I have so far that allows me to change the recordset to the one that I need, but What I need to know is how to change it back. I have tried using the same code to change it back with a different strSQL name(the table name of the data I originally used) but that does not seem to work. I am not opposed to getting the data from the second table a different way, but I am at a loss for ideas as nothing seems to work well. Thanks in advance Dim cnnCustomerdbnew As New ADODB.Connection Dim customerdbnew As New ADODB.Recordset Dim strSQL As String With cnnCustomerdbnew .Provider = "Microsoft.Jet.OLEDB.4.0" .Open "\\Backup\hosted files\CustomerDatabase\customerdbnew.mdb", "admin" End With strSQL = "customerdbnew" With customerdbnew Set .ActiveConnection = cnnCustomerdbnew .CursorType = adOpenKeyset .CursorLocation = adUseClient .LockType = adLockOptimistic .Open strSQL End With Set Me.Recordset = customerdbnew (or if you know of any way were I don't set the recordset, but I still can access the fields inside the new table that would also work (better if possible)) -- Message posted via AccessMonster.com [url]http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200508/1[/url]

I have no experience with SQL server and have been asked the following questions: If the owner of a split Access database (frontend/backend) wants to upsize to SQL server can it be as simple as migrating the backend tables to SQL server, link the frontend to the new datasource and do nothing else? Will anything be broken? Can the frontend linking be set up at a remote location without having to actually visit the site? This is the case at the moment. Frontend is linked to appropriate Jet backend file path and then emailed to the user who installs them in the same file path location.

Quick question. Can i do the falling with the Calendar Control 11.0 object. I work for a company that deploys marketing emails. Currently, sales reps and advertisers call or email me to book a email deployment date. Using excel, i check for availability, and if teh email is good to deploy in what ever week the request, i add a comment over that requested date in excel. With this calendar control, can i have the sales rep themselves open up the database containing the calendar, click on a date in which they want to deploy, and fill out a "request form" of sorts with info such as name of email, citys/provinces deploying to, time etc.??? and have that form sent to me, or added as "updated" in the database? Of course there way more specifics i would like to include, such as only allowing city's to be booked 3 times a month, so for instance if 2 emails are scheduled to deploy to all of Canada, and a third email only to Toronto, that means a 4th email is ok to book provided it leaves out Toronto (as it would have been booked 3 times prior 2 National + 1 Toronto only)

I can't seem to get my form to show datasheet bt default. If I run it from the databse window, it works just fine. But called from a button on a different form, and it goes to form view instead. I have the proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet" -mjm

I have a relatively straight forward report. The query that populates data for this report is complicated. The report opens without any problem and I can print it as well. However, If I have another form open (has about 12 combo boxes) and then I run the report, it appears on the screen, no problem. When I print the report, I get 'Cant open any more databases' error. I am using OpenQuery method to run some queries before opening the report. I am just wondering if I should use qdf.execute method, will that help any? Obviously, having that additional form open is creating the problem. Does anyone know what is the maximum limit of the open recordsets? -Niranjan

Access2002 (10). Every time that opens a form, in the Windows application bar, to appears a new icon, like if it were a new one task. It's possible to avoid that? Thanks for any Help Roberto Casaccia (Italy)

Hi, Not sure if this would be possible without using vba or similar programming, but can I use sql to create a column of dates in a regular sequence (such as weekly, monthly etc.) I would like the results to be e.g. date 01/01/04 08/01/04 15/01/04 22/01/04 29/01/04 Many thanks, Chris

Hello all, I'm building a database for a high school academic convention and the big task for this DB is to sort out the contest winners. Here's the tables (slightly simplified): tblDelegate ----------- DelID LastName FirstName School etc. . . tblContest ---------- ContID ContName etc. . . tblResult --------- DelID_FK ContID_FK Result My question is how do I query so that I get the top three places in each contest, including ties. So if Bob, Sue, Adam, Cindy, and Joe each take the test in Latin Grammar and the Scores come out 10, 10, 9, 8, and 7 respectively, then the results should be 1st: Bob and Sue 2nd: Adam 3rd: Cindy with Joe not placing. Using the top predicate would return just the 10s and the 9 so Bob or Sue would be returned as the 1st, 2nd would be the other between the two and Adam would be third. Does anyone any have idea of how to approach this? Thanks, -Carlos

Has anybody else seen this? When I use Access 2002's label wizard, the top row of labels is always too far askew to print properly, while the rest are fine. What's up with this? Rabbi Harry Sky ========== Please visit my website at You can order my new book, My Journey, by clicking on the link below: <[url]https://www.paypal.com/xclick/business=rabbi%40maine.rr.com&item_name=My+Jo[/url] urney+%28paperback%2C+1st+ed.%29&amount=18.00&no_note=1¤cy_code=USD&lc =US>

I am using Jan Goyvaerts excellent HelpScribble program. I am having a problem though with running an external html file from the help file within Access. I click the button, the button moves down, but nothing happens. If I open the CHM file externally (not from inside Access) the html file opens fine. If I invoke it from within HelpScribble, it is also fine. Something in Access prevents it working as intended. Has anyone had any experience with this problem in HTML help?

PHONELLA PHONELLA PHONELLA PHONELLA PHONELLA PHONELLA Phone Cell Mobile Cards Phones Free Long Cellular Prepaid Distance Service International Calling Games Wireless Cheap Nokia News Telephone Information Online Accessories Number Plans Rates Directory Find Reviews Business Card Reverse Book Call Ringtones Systems Compare Discount Numbers Software Tones Yellow Calls Internet Local Pc Search White Cash Motorola Services Email Help More [url]http://phonella.blogspot.com[/url] [url]http://www.phonella.com[/url] PHONELLA PHONELLA PHONELLA PHONELLA PHONELLA PHONELLA

Hi I have a query about exporting individual records from an Access form to an excel template. Basically I have a number of clients and on the main form I can run through each individual job and its associated information. I would like to export some of the fields onto an excel invoice template (so they must be individual records). Ideally I would be able to place the fields into specific cells on the template. The fields on the main form come from three separate tables. If anybody has some ideas out there it would be appreciated. Cheers, Mike

The database I am working with contains a field with as many as 12 different values (09,10,11,12,13,14,15,16,17,18,19,20) My end user has requested that the number of times these 12 different values appear in the table be grouped in the following 8 groups (15 or 19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10) That is, for example, the end user wants the combined count for the total number of times (15 or 19) appears in the table. I created 8 queries for the above 8 groups (15 or 19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10) though I don't think the queries for the 4 groups containing two possible values work correctly or any of them for that matter. How do I set up my query for these 8 groups? And especially how do I do this for the 4 groups containing two possible values? How do I show, on a report, only the the counts for the number of times these 8 groupings show in the table?

Hi, I've got a form which logs various issues. What I'm after is a blank version of this form where I can input data. Then hit a button and it finds all records with that data. I remeber doing this at uni a few yrs ago - but typically, in the workplace I've forgotten pretty much everything. Any help would be greatly appreciated. Cheers Zieshan

I have a production table and its accompanying form. There can be up to ten ingredients in what is produced. The ingredients are obtained from the incoming goods table which supplies the two parameters that I use, "Name" and "CatlogNo". This production table needs to contain each ingredient by name and catalogue number. With help from this list I was able to set up a combo box that allowed me to select a particular ingredient, and when I did, the catalog number was automatically filled in. Worked fine! Then I went down to the second ingredient and there I ran in to trouble. As the field "CatlogNo" was being used in the previous combo box on Ingredient number one, I could not use it again. Now I'm stuck. Is there a workaround for this sort of thing? Any help would be appreciated and please realize I am an absolute newbie with Access. Thank you, Bill. -- William Bradley Come visit us at: [url]http://www.catholicmissionleaflets.org[/url] Free Rosaries available at the above.

I'm trying to develop a thing, even if I don't know exactly for what I need it; however I'm sure that it's an useful code. I want to realize a routine that make dinamically a query: starting from some table and field, I want to realize a "right" query to visualize datas. Two are the teoric most difficult: - table relationship - bidirectionally of process Stating that I'd want to make this on MS-SQL and on MY-SQL, even of in MS-ACCESS, I need to know: - there are tools that do this - there are pratical obstacle that I don't know now - is there in MSA a realationship object to use (and is there in other like MYSQL or MSSQL) Thanks Gianluca

Dear All, Is it possible to check how many users loged in in the current access database.In Sql Server the command is sp_who in Db2 List Application.What is in Access.Or is there any thing in round about manner????? Regards Arijit