Search results for query: *

Hello all, I'm currently using Lebans RTF tool on a form and report. The control source of the RTF is the same table field (named "Analysis") for both the form and report. For the RTF control on the form, I set the default font size to 14. For the RTF control on the report, I set the default...

Hello all, I apologize in advance for the long question, but I wanted to make it clear..... This is a problem I've had for quite some time now and it seems to be erratic. Sometimes my forms enlarge automatically for an unknown reason. Meaning that, I have forms that are originally sized at...

Hello all, I'm currently using Leban's RTF2 ActiveX control on my forms, which works great (it allows text formatting). Now I need to "tweak" my reports to accommodate the formatted field. My old reports are designed so that the field in question has: Can Grow = Yes Can Shrink = Yes How...

Hello, I have a very general question about memo fields on forms. Is formatting only certain text in memo fields allowed? For example, I want to bold only one word in a sentence in the memo field. Whenever I highlight and bold the word, all words in the field are made bold also. I don't want...

Can anyone please help me with this vba code? I'm trying to set a label caption on a subform, depending on the "IndxType" value on the main form. This code is on the subform's OnLoad event: Dim indextype As String indextype = Forms!FrmSearchIndexMain.IndxType If (indextype = "Mkt") Then...

Can anyone please help me with this vba code? I'm trying to set a label caption on a subform, depending on the "IndxType" value on the main form. This code is on the subform's OnLoad event: Dim indextype As String indextype = Forms!FrmSearchIndexMain.IndxType If (indextype = "Mkt") Then...

Hello all, I'm having a bit of trouble trying to understand why the following two queries return empty sets: ---------------------------------------------------------- SELECT * FROM A, B WHERE A.ActualRelease <> B.ActualRelease; ---------------------------------------------------------- SELECT...

Hello all, I'm having some problems with the following DELETE query: DELETE TblHistory.* FROM TblHistory, TblHistoryTemp WHERE TblHistory.Name = TblHistoryTemp.Name AND TblHistory.Release = TblHistoryTemp.Release AND TblHistory.Period = TblHistoryTemp.Period; When running it, I receive this...

Hello all, I've tried using all the suggestions provided in relevant threads to help me with this problem, but to no avail. Thanks in advance for any/all help.... I am able to successfull print out a report in the snapshot viewer. My problem is when trying to email it. Even when previewing...

Hello all, I have one main form that contains 3 subforms. These subforms are based on one table. Esubform works off different filters to display different sets of data from the same table. Anyway, here's my problem. Each record on every subform contains a date field and several text fields...

Hello all, I have a filter correctly working, based on two date fields on a main form, which displays data on a subform. My problem now is that I'd like to include an "If" statement for when the date fields are blank. Here's my code: Private Sub ApplyDates_Click() Dim FromFilter Dim...

Hello all, I have a main form that contains two textboxes (FromDate and ToDate) and a button (ApplyDates). When clicking on the button, I'd like to use the dates inputted into the textboxes to filter out data in a subform (SubByDate). The data displayed should be between the two dates...

I have a combobox on a form, with other textboxes whose values depend on the value selected from the combobox. When I make a selection from the combo, the other textboxes are correctly updated with the associated data. However, I've noticed that I'm always on the first record. The problem I'm...

In Windows Explorer, I see that there is an associated .ldb file with my .mdb database. I usually see the .ldb file only when there was some kind of error while I had the .mdb open and was "kicked out". In order to get rid of the .ldb files, usually I open the .mdb and exit properly (via...

I've been experimenting with splitting my database into a front-end and a back-end. Here are the steps I followed: 1. create a blank db for the front-end (FE-DB). 2. while in FE-DB, imported all non-table objects from original DB (which I now consider the back-end db). 3. in FE-DB, linked to...

In one workbook, I have a macro that prints out multiple pages of a data at different times. Specifically, calculations are performed at different times on different ranges of the worksheet/workbook. There is a footer set up to print out the page number. Currently, "Page 1 of 1" is printed out...

I'd like to get the last modified date of a file and compare it to the system date. So far, I've only been able to come up with FileDateTime and Now functions, which includes the time. But I don't want the time included. Are there any other functions that I can use or is there a way for me to...

I'm new to Access/SQL, so please be patient. Thanks. I am trying to write a query (I'll call this "Q2"), based on the results from another query (I'll call this "Q1"). Q1 simply gathers and displays all fields from several tables, based on Company Names, and displaying only the most recent...

Hi, I'm trying to figure out how to autofill/filldown a range in which the number of rows may change periodically. I'm using a variable to store the number of rows counted, but don't know how to incorporate that variable into the autofill/filldown. Here is a sample of my code...

I'm new to Access, so please be patient. Thanks. My question is whether or not command buttons are customize-able in Access (2003). Instead of a square/rectangle, can I make it a circle instead and also change the colors? If this is possible, how is it done? Thanks.