Search results

Hi All I have used Allen Browne's code (see http://allenbrowne.com/ser-16.html, bottom of page) as a model for my user-defined type and public function in an events management database. Using the function in forms/VBA works fine. But my DB crashes whenever I try to use it in a query. My...

Hi All Has anyone noticed that when in database detail (not list) view, looking at the forms objects screen for example, there is a "created" date and a "modified" date for each form , but when you look at the MsysObjects table, the "datecreate" and "dateUpdate" fields have the same info...

This is for a Seminars Database: I have a form with an unbound combobox (SeminarsCombo) in the header section used to select a Seminar. The detail section of the form is hidden. The "afterupdate" event of the combo causes the detail section to become visible and display info for the selected...

Hi All Is it possible to have a combo box where the available selections are derived from a table AND custom data. Situation: A master table has a list of publications, in format MMMYYYY, viz. JAN2007, MAR2007, MAY2007, etc (it's a bi-monthly journal) We are tracking advertisers in each...

Hi All I'm sure this is simple, I have a mental block on how to do it. I have two tables in a 1 to many relationship, TableOne and TableTwo. (ie. Company and Locations, linked on CompanyID.) My main form has a combo box to select a record from TableOne. This works OK, displaying TableOne...

Hi All My problem: We update our accounting system customer details from an A2K db, via an export/import/ODBC interface. Works fine. Unfortunately the accounting system will not overwrite existing data with blank/null information. So when a customer's address changes from a two line address to...

Hi All Anyone had any experience of looping through a recordset, creating individual report files (preferably PDFs) based on customer/member number, and then FTP'ing each report to another location? We want to enable members to view reports on our website rather than send them in the mail, as...

I have three tables: tblCompany (one to many) tblLocations (one to many) tblPersonnel. The relationships are all ERI with cascade updates (but not cascade deletes) I have a form showing company details (name etc from tblCompany) in the header with multiple subforms (each on a tab) for each of...

I have a need to identify unique values across multiple records that are attached to a higher level entity, and concatentate this information into a memo field attached to the higher level entity. Explanation: tblLocations: Location ID, name, address, etc One to many tblServiceTypeMatrix...

I have a Company form, a typical form with fields for capturing company names, address, phone etc. The two fields I have an issue with are: CompanyName: a regular text field for full company name ShortName: a regular text field for same data as above but with spaces/blanks removed (to be used...

I have a weird situation. 2 PCs out of 7 will not print a report as designed, the other 5 do. Same report, same printer, same printer drivers installed. The report contains text fields in Times New Roman and Arial (standard Windows fonts!), yet ONLY SOME of these fields are being printed in...

Environment: Access2000 Database running under on workstations that are running Access2003. We have a routine that reads our database and updates email addresses to Outlook2003 Contacts on the workstations. (It's activated by a button in the Access application, so users can do it whenever they...

Hi All Has anyone experienced this: I have a datasheet as a sub-form on a main form. Because the main form is accessed from 2 different forms in the system (let's call them A and B), I hide a column on the datasheet that is not relevant when the access is from Form B. This was working fine...

John471 recently gave me a nice piece of code to insert blank records in an export file. (refer my previous thread) Unfortunately this uses the WRITE # function, which I believe will only write a CSV file. It's unfortunate because the application that will use the exported file will only...

I am exporting customer order records to another application from Access2000. The receiving application needs a blank record as a "separator" when the customer name changes. Customers can have any number of order records in the table. Simply put, I need to read an Access table, writing each...