Search results

Just curious how many others go about building databases this way, and if they notice any slowdowns due to excessive code. In regards to form states (form in edit mode, add mode etc.). I run code in the OnCurrent event that checks if the current record is a new record, if it is then "Save" and...

Hello, not sure exactly where to put this one.. Am using VBA code to open an instance of Excel, and copy data into a premade template. I have memo fields that are often over 255 chars, and when pasting it into Excel only 255 chars appear. I need a way to fix this. Access 2003 -> Excel 2003...

Hello, If you wish to design a front end that controls, let's say many backend individual databases, is this manageable? Let's say I have 20 backend databases that I want controlled through a single frontend, would it be manageable as long as I had a specific prefix for each 'module' or...

Hello, I created a help file using the Microsoft HTML Help Workshop. I went into the API settings and created an alias of "1 = t1.htm". On the Access form properties, I set the HelpFile to link to the .chm, and set the ContextID to "1". However when I press F1, The help window that comes up...

Hello, Let's say I have a master form, which has two One-to-Many continuous subforms. If I wanted to be able to filter the results based on subform values (for example, show all master records which has a subform record equal to 'Product Name', this way I can filter out all 'Companies' that...

Hello, Just a quick question because I am unsure of the technical specifications of each. Which is faster to lookup quick information, a DLookup or a Recordset. I have security built into the form to check the username, and show options appropriately. I originally made the code using...

Hello, I am creating a database that is used to track lots of different types of documents. Such as letters, reports, books, etc. However the actual tracking of the transactions of the documents is identical. Which scheme is best. Scheme 1: Each type has it's own table with it's own unique...

Hello, This is a weird problem that I am stumped by. I have a combobox that automatically filters the form after something is selected. This is a tabbed form with tabs separating information located in the same table. For example, the top 10 fields appear in tab one, the bottom 10 fields...

Hello, Weird thing with Listboxes here... I have buttons that allow me to navigate up and down a listbox, the following: For i = 0 To lstTest.ListCount - 2 If lstTest.Selected(i) And move = False Then lstTest.Selected(i) = False lstTest.Selected(i + 1) = True...

Hello, I was taught that having a loop of relationships is a bad thing to have. My dilemma comes from the following: I have a table let's say that has user data, which contains a field for Province, and City they live in. Now, clearly City and Province have to also be related. This would...

Hello, Slight problem getting this to work... Let's say I have tblMain and tblSub. tblMain has an ID, and tblSub has an ID2 Autonumber, ID (Linked to ID from tblMain), and then some other fields. Form1 is based on tblMain and Form2 is based on tblSub. I have a button on Form1 that is...

Hello, I have a database which has a VBA procedure that takes lots of data from the tables, opens Excel up in the background, uses a template to paste in the data into the correct places on the Excel sheet. Unfortunately, because of one to many relationships, rows have to be added in certain...

Hello guys, I am working on a database that requires a user (with very little access knowledge) to export a table into .dbf (DBase IV Format) using a button and VBA. I realize this can be done by right clicking on a table and click export. However I did not give the end user access to the...

This is a weird error that appears to occur randomly for me. I have a report named rptYearlyTimeReport that has two textboxes in the header that are filled in as shown: =[Forms]![frmYearlyReportCriteria]![txtStartDate] =[Forms]![frmYearlyReportCriteria]![txtEndDate] The form...