Recent content by planetdrouin

I am trying to write an array formula which also looks for a substring. Essentially one of my data fields could contain "john 2003-4" I want to be able to say look for "2003-4" in that column. My other parts were fine such as matching the date and using the first 5 letters...

Thanks for the quick reply. Currently I don't have any direct method of determining a difference between a directory and a sub directory. However, by definition, if a category is a directory, then no category with the same numerical prefix but with more numbers will exist. For instance...

Have you deselected all the 'Name AutoCorrect' check boxes which is found under 'Options' then the 'General' tab. By doing this, you will greatly improve the speed of your app. Lawrence

I have a table which contains a list of categories which looks like: Category ID Category Name 11 Cash 111 Petty Cash 12 Bank Account 121 Citibank 122 Wells Fargo 21 Utilities 211 Telephone 2111 SBC 2111...

On more thing, my form is in datasheet and not continuous (I wish I would check my spelling a little more often) view.

My code correctly populates each of the unbound controls on the first record, but each subsequent record has the same data as the first. I am rather new to programming, so I am must be missing something rather simple (I hope). My code looks like: Private Sub Form_Load() Dim intX As Integer...

Hello, I am trying to implement code from here to check FE version and to update it if necessary. The two threads for the code are faq705-2010 and faq705-1971 . My problem is arising when I try to set the recordsets. I get a run time error 3112, which is 'records cannot be read; no read...

Hello, I have a query which essentially brings in two tables. They are TblInvoices and TblReceipts. Both tables look like (with some other fields): Date InvoiceID ClientID Amount However, the InvoiceID is unique in TblInvoices but not in TblReceipts as some customers pay in multiple...

Jeff, Sorry I haven't gotten back to you sooner, but have been out on the road. Your reply was extremely helpful and works like a charm. I agree about the date, my field was actually named [InvoiceDate], just being lazy in my question. Lawrence

Hello, I am relatively new to Access, so... I have a transaction table, that has a date, description, transaction category and amount. I want to sum the transactions by fiscal quarter and year, where fiscal quaters are Nov-Jan, Feb-Apr, May-Jul, Aug-Oct. The resulting output would look like...

Hello, I am rather new to Access, so... I have a split database, with some seldom changed tables remaining in the front end. I would like to be able to add code to my front end app, such that everytime a person logs on, these front end tables are updated with data from back end tables. These...

If I am not mistaken, to allow users the ability to compact they need to open Access in "open exclusive" mode. If my DB is split between a front and back end, can all users be given "open exclusive" permission on the front end so I can automatically have the DB compact on...

I have a form which has a tab control with 5 pages. On one of the pages is a subform. I am attempting to add Me.Dirty then Me.Undo logic to an exit button. Is this possible with tab pages and especially with a subform on one of them? Thanks Lawrence

About a month ago I saw some code either here or "The Access Web" which allowed you to change a particular property on all forms. For the life of me I can't seem to find it again. For instance, it was very useful for changing the menu bar property on all forms. Does anyone happen to...

About a month ago I saw some code either here or "The Access Web" which allowed you to change a particular property on all forms. For the life of me I can't seem to find it again. For instance, it was very useful for changing the menu bar property on all forms. Does anyone happen to...