Search results for query: *

Hi, I am trying to write an automatic number generator for an issue tracking system. The number should look like this: 08-06-003 Where 08 represents the workplan section related to the issue. 06 represents the year during which the issue was created. 003 is the number of the issue in...

Hi, Is there a way to combine 2 SQL statements into 1? Query1: SELECT itsTbl.itsNo, itsTbl.workplanNo, itsTbl.workplanSectionNo FROM itsTbl WHERE (((itsTbl.workplanNo)=[Forms]![itsNewFrm]![workplanNoCombo]) AND ((itsTbl.workplanSectionNo)=[Forms]![itsNewFrm]![workplanSectionNoCombo])); Query2...

Hi, I am trying to write an automatic number generator for an issue tracking system. The number should look like this: 08-06-003 Where 08 represents the workplan section related to the issue. 06 represents the year during which the issue was created. 003 is the number of the issue in...

Hi, How can I have a null sbureport not leave large gaps in a report? I have all fields CanGrow and CanShrink set to yes. When null, the subreport is invisible, but still takes room in the report. Thanks, John

Hi, How can I open a database from within another database? Do I use the OpenDatabase command or the Shell command? The 2 databases are independent from eachother. How do I use these commands efficiently? Thanks, John

Hi, I have the following code attached to several subforms. Private Sub viewCommStratBtn_Click() On Error GoTo Err_viewCommStratBtn_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "ITSCommStratsFrm" stLinkCriteria = "[ITSCommStratsID]=" &...

Hi, I want to create a query from 2 calculated queries. Query1 contains several rows yearNo 'year part of the date of birth numBirths 'number of births for that year logNumBirths ' natural log of numBirths Query2 (from Query1) contains 1 row n: Count(*) 'count number of records in...

Hi, Can any one tell me how I can create folders and subfolders from MS Access (VBA)? Thanks, John

Hi, Is there a way to add an "Issue Number" (user-defined) field to the Event/Apointment screen of the Outlook Calendar? Thanks, John

Hi, Is there a way to add an "Issue Number" (user-defined) field to the event screen of the Outlook Calendar? Thanks, John

I created the following query: SELECT personelTbl.name, personelTbl.phone FROM personelTbl Where ((personelTbl.name) = (Iif ([Forms]![personelReportFrm]![nameCombo] = "All", " ", [Forms]![personelReportFrm]![nameCombo]))) If a single name is selected in nameCombo, the query works. If "All" is...

I packaged an Access application for distribution using Office XP Developer. The Acess toolbar does not appear in the application. Can anyone tell me how to fix this problem? Thanks. John

Hi,Can someone tell me where I can find comparison articles between Windows 2003 and Netware 6.0-6.5? Thanks, John

I have a mailout report in Access97 formated in No. 10 envelopes. Whenever this database is moved or copied onto a different machine, the paper size changes back to letter. Any ideas why this is happening and how to fix it? Any help is greatly appreciated. Thanks, John

Hi, Can you show me how I can open a Word file from an event procedure (button OnClick)? Thanks, John

Hi, I have used the following declaration dozens of times: Dim db As Database Now, I get the following compile error: "User-defined type not defined" Any ideas? Is Access corrupted? Thanks, John

Hi, Is there a way to import Lotus Approach tables into Access 2002 (other than buying the Lotus SmartSuite)? Thanks, John

Hi, Can anyone help me with the following? I want to create a report that will show people's birthdays grouped by month. I have a table that contain the following fields: [Name] [DateOfBirth] I also want the group header to show the relevant month. Thanks, John

Hi, I imported a databese from '97 to 2002. I get the following error message when I try to open some (not all) reports in my database: "There was a problem retrieving printing information for this object. The object may have been sent to a printer that is unavailable." I get this...

I created table that contains membership information: ID -> [AutoNumber] GroupNo -> [Text] 3 characters Position -> [Text] 2 characters LastName -> [Text] 50 characters FirstName -> [Text] 50 characters Age -> [Number] Byte The [GroupNo] represents...