Search results for query: *

Hi I have a saved report with a saved qry as the datasource with a [select ID] parameter on the ID field in the qry. I have VBA code that prompts for the ID and exports the SNP report to a folder. I do not want to open and read the report, I just want to generate and save it. However, I want...

Hi, I hope someone can help me with this. I have a table with 26 fields in each record. Is there a way to find the field name in each record that has a specific value? for example, 26 fields named 'a', 'b', ... 'z'. each field has a different numeric value. I want the field name for each...

Hello I want to use DAO to loop through a large file in ascending [date] field sort order, and for each record, evaluate the record's [amount] field. If the [amount] field is null, I want to append the dollar [amount] value from the prior (i.e. most recent prior date) field to the current...

I'm stuck even after looking through other DLookup posts for solutions. I have a table of exchange rates and a table of activity dates. I want to get the exchange rate for each activity date. However, in any given month, not every day will have an exchange rate, and not every day would have...

Hello I have a module in a A.mdb to auto create a new B.mdb and then export a table from the A,mdb to the B.mbd. It works fine with a hard coded table name. I'm trying to figure out how to have a list, populated with tables names from A.mdb, pop up for the user to select the table(s) that...

I'm hoping someone can help me. I have a qry with two tables: tblParent (100 records, 5 fields) and tblChild (300 records, 8 fields). I am trying to produce a query that generates a list of the 100 parent records with a 6th parent field that represents the child region value having the highest...

Is there an easy way to do this in a union qry? I am trying to create a qry on a single table to select the Captain from the Team based on Goals, and then associate that result with each record. Below illustration makes the point clearer I hope. Is this doable? Any help would be much...

Hi I need to create a field expression to evaluate two fields from a prior record but I'm not sure how to do it. I have a table with fields including dollar amounts and dates. I can Desc sort on dollars and then dates, and need a 3rd field that evaluates the preceeding dollar and date against...

Hi - I cannot get the 1st outer loop to perform, but the 2nd iner loop seems to work fine. This code is basically trying to evaluate each name field against every other name field in a table. The code compares the 1st name to all the others, but never moves on to the 2nd name to repeat the...

I'm baffled. I have a simple form with an unbound listbox, rowsource is a select statement. A command button has code to read the number of selections highlighted, and then calls a function to take info from each record and populate a Word template. Works fine. I have another form, same...

Hello I have a form with a Pagectl with several tabs. I need to give the form user the ability to print the form and show the tab selected. I can print the form, and it shows the data from the tabe selected, it just doesn't identify "show" or "print" the tab that was selected. Is there a way...

Hello Can anyone point me in the right direction on this? I have a form used to enter event data to a table. On the form I have a page with several tabs. on one of the tabs I have a subform to capture the names of attendees. If I load the form and edit a record on the form, I can use If...

hello I have a form with a subform, and had used the the following code which worked fine: Me.Form.frm_Participants_subform.Locked = False I changed the form to use tabs, and placed the subform on one of the tabs. Now that code no longer woks. I've tried everything I could find on TT and...

Hi I have an Access2003 database I use to open a MS Word template (its a form users will complete when sent out)and fill in certain bookmarked areas with info from a query. - works great. However, I also need to edit the header and footer (same on all pages) with some of the data as well, but...

Please any suggestions? I have a report that I need to display amounts in dollars, euros, and pounds, all on the same report, but I cannot seem to find a way to so. I can change the language settings to get dollars and euros, but not pounds, or select the UK to get pounds but not euros. Isn't...

I want to generate a table in access with a list of pdf files on my hard drive and include the properties (like Title, name, etc), but I can't seem to find anything on the subject in VBA. Can anyone point me in the right direction? Many thanks

Hello - I have a lot of pdf documents on my hard drive and I'd like to know if there is a way to populate a table with the pdf file properties (filename, title, author, subject, keywords, number of pages). Is it even possible? I cannot seem to find any help on the subject, and the search...

I have users who for whatever reason need the excel4 formated file, but in an Access2K or 2003 database the acSpreadsheetTypeExcel4 generates an error. It works fine in an access97 database, but not the 2K or 2003 databases. My code is below. changing to excel7, 8, 9, 5 all work without an...

I can't figure this out - I auto-create and mdb in A2K using a vba routine and transfer tables to populate it with about 8 tables. Size is 187 meg. mdb seems file - data looks ok etc. when I zip it using winzip it actually INCREASES the zipped file size slightly. Anyone have any ideas or...

This is driving me nuts. I have a qry that returns a running sum, but the numbers sometimes skip a value, and it's not always the same value that it skips: SELECT x.Points, x.[PlayerID], x.Eventdt, (SELECT Count(*) FROM tbl_Data WHERE Points < X.Points OR (Points = X.Points AND [PlayerID]<=...