Search results

Hi, I have two forms in my database: Form1: list of records (which have the status 'open') Form2: shows details of chosen record in Form1 (status can be set on 'complete') When the status in Form2 is changed into 'complete' this record will disappear in Form1. If the status stays on 'open' the...

Hi, I am working on a report and I am stuck with the following problem: Here at work we use two tables. One for creating records and for the updates of the created records. In the attachment you see a part of the table 'updated'. What you see is one ServiceNumber (1-551747091) which is changed...

Hi, I would like compacting my database automatically with my task scheduler. In this forum I found the following topic with the solution... I thought: http://www.access-programmers.co.uk/...ad.php?t=98123 My database is only a .mdb Access 2000 file and contains a general password (access)...

Hi, I have a problem with getting the right result with a query. To this topic I attached a part of my database including 2 queries. The queries are almost the same, except the first field. In query 1 is the total 'Group By' and in query 2 'Count'.The other fields are parameters, which are the...

Good morning! :) I have 2 forms (frmRecordList and frmRecordDetails). The form frmRecordList contains 400+ records with a field 'Status' set on "Open". Normally I choose a record in frmRecordList and frmRecordDetails shows the chosen record. In frmRecordDetails I am able to change a field...

To control Excel in my database I use the following code: objActiveWkb.Worksheets("Mutatiesoverzicht").Range("A2:C2").HorizontalAlignment = xlLeft By running the code I get the following error: "Unable to set the horizontal alignment property of the range class" I think the problem is the...

Hi, I searched the forum for my problem but I didn't find the solution. :( I want to export a query to Excel, but without saving the Excel file. It's similar like copying manually the query results in Access and paste them in a new Excel workbook/sheet. I would like to automate this. I also...

Hi, I have the following sub (see below). This sub saves 3 worksheets as 3 seperate Excel files. During the procedure I get the following question with the options 'Yes' and 'No': Do you want to save changes before switching file status? I want to automate this procedure so that I don't have...

I got an assignment from my supervisor and I am not getting it! :( I have a query (see result in attachment) with the following fields: tID, emailID, emailtype and EmailDate. Example: A customer (tID 1297542) sends an e-mail (emailtype 1) to the company on 2-8-2005. The company replies on...

Hi! :) I would like to show the worksheet tab name in a cell of that specific worksheet? Is this possible with a formula in a cell?!?

Hi, Every week I get a spreadsheet from a database. In this spreadsheet is a column 'DATE', see attachment. This column is filled with (many) dates but they are not correctly typed like DD-MM-YYYY. :( For example: 20051210 should be 10-12-2005 (DD-MM-YYYY). Is there a way to convert this...

Well, I am stuck again with my weeknumber problem... Mile-O-Phile, yes... you're right again! Damn... ;) [Problem] I would like to enter a weeknumber and the begin date and end date of that week will be saved in a table. For example: I enter weeknumber 1 and the dates 01-01-2004 and...

I am stuck with the function DCount... I have the following problem: I use: tblContracts ============ AutoID ContractID - numeric Week - numeric Price frmContract ======== txtContractID txtWeek txtPrice [Question] I would like to check if a contractID contains Week 0 (zero). Criteria...

Hi, I am stuck with the following problem: [problemsituation] I have a table tblContracts with the fields week1, week2, week3... week52. In these fields are prices. I have a query for a report which shows the orderinput per week. [problem/question] In the query is a weeknumber present. I...

Hi, Problemsituation (see attachment): I have a subform to fill in the input and output items in our company. The fields you see will be saved in the table tblStock. Description of the fields: [IN] ITEM -> combo box with item names from table tblItems WEIGHT -> weight of the item # -> the...

Hi, Problemsituation (see attachment): Within a contract are many numbers (afleveringsbonnummers). These numbers will not display in more than one column, see figure 1. Own solution until so far: The data in the green shape is in the header of the group 'Contractnummer'. I put the text field...

Hi, I would like to display the page numbers on the pages of my report, but only if the report is more than one page. How to do this in the design and/or VB area?!? Thanks in advance, JiTS

Need some Duch help... Hi, I need some help in Dutch. I am busy with reports now and it's too complicated to explain it in english. I am not able to search for Dutch people in this forum... If there are Dutch people over here who are good with reports, please reply. Thanks in advance!

Hi, Problemsituation (see attachment): I have a report with a couple of text boxes and one checkbox. Question: I want that the checkbox checks if the field (productcode) the text "VB" contains. If so then the checkbox will be checked (true). Own solution until so far: I added the following...

Hi, I searched the forum for this problem but my problem is still unique. :( Problemsituation (see attachment): I have a form (frmAanvoergegevens) with 3 fields: * Contractnummer - txtContractnummer - textbox - numerical * Productcode - cboProductcode - combo box - text * Leverancierscode -...