Search results

I hope I've posted this in the right place - apologies if not! I appear to have a corrupt form within my database, and it will take forever to recreate it from scratch so I was hoping to try what a few people seem to have suggested, which is to use Application.SaveAsText to export it, then...

Didn't know quite how to word my title, and hopefully have put this in the right place! I am running a query which has now decided to tell me that "The record source "SELECT [RECEIVED BY].ID, [RECEIVED BY].[RECEIVED BY] FROM [RECEIVED BY];" specified on this report or form does not exist."...

Hi guys - no idea if anyone can help but we have a database at work that we use daily to input data (using forms) but the main form we use now won't open. I have tried every way I can think of to get at it, but it almost appears that Access can no longer "see" the form. You can copy and paste it...

SOLVED: Select query not working... only showing 14 records out of 48! Hi all - I'm stuck. I have (currently) 48 records in my database, and I am running a query to bring back all records since 1st April - it just happens that everything in there only goes back to 1st April. For some reason...

Hi everyone I hope someone can help! I have 4 combo boxes on my form, all bound to tables. They are called cboDivision, cboServiceArea, cboArea and cboTypeofService. cboDivision populates cboServiceArea (depending on your choice), which then populates cboTypeofService. cboDivision also...

Hi there I'm using a subform which has 3 combo boxes in it - the 2nd one is dependent on what you pick from the first, and the 3rd is dependent on what is picked from the 2nd. I have code in the "on change" event procedure as follows: Option Compare Database Private Sub...

Hi everyone I've tried searching, but nothing came up that helped, so I'm sorry if this has been answered before. I have a main form, which contains a subform. My problem is that when I create a new record on the main form, a new record is created in the subform (correctly) but if I go back...

Hi all I hope someone can help me with this. I'm trying to put a custom record counter on a subform, but the code I am using doesn't seem to work. This is what I am using (on the subform module): Private Sub Form_Current() Me.RecordsetClone.MoveLast...