Search results for query: *

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...

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...

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...

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...

I have a form that allows users to change their own Access built-in security passwords using the code: Set wsp = DBEngine.Workspaces(0) wsp.Users(CurrentUser).NewPassword Nz(TxtOldPassword), Nz(TxtNewPassword) However, I would like to add code upon startup which checks to make sure the users...

I have a form that allows users to change their own passwords. However, I would like to add code upon startup which checks to make sure the users password (Access built-n security) is not null and if so open the change password form. Does anybody know how to do this? Thanks Lawrence

Does anyone have any suggestions on how to compact the database containing linked tables? Thanks Lawrence

I currently have a form that allows users to change their password. But I would like to run a function at startup to check if the user's password is null which would then open the form. Does anyone know the proper syntax to check existing password? Thanks Lawrence

I have a form which creates Invoices. First the user selects a ClientID on the main form, which then refreshes data in the subform. This part works fine. What I want is for the subform to list out all the Employees names and amount of unbilled time for that client. What I currently have is...

Does anybody have any code that shows which groups a user is a member of? I have code that adds or subtracts a user using a form with an unbound field. But I would like some way of showing in a list box which groups a specific user is a member of. Thanks for any input. Lawrence

Does anybody have any code that shows which groups a user is a member of? I have code that adds or subtracts a user using a form with an unbound field. But I would like some way of showing in a list box which groups a specific user is a member of. Thanks for any input. Lawrence

I have a form that is supposed to delete the user information as far as security is concerned and also delete the employee's contact information. On my form I have one input field that is unbound and a button to delete information. The error I am getting is "The Microsoft Jet database...

I am relatively new to Access, so this may be a moronic question, but the help would be greatly appreciated. I have a form (call it form A) that shows all transactions by client ID with the ability to dig down and see details (on another form, form B, which is the original entry form). I...