Search results

Hi all - I'm working on an access db that contains 3 tables 1) Member Table 2) Address Table 3) Contracts Table Then I have a form that pulls them all in together with subforms as the Address & Contracts attached to the Member Each week someone goes out to another source and pulls in new...

Is there a way for us to hide all of the tables, queries to only show the form for the person doing data entry? Thank you

Is there a way to change the highlighting in a form when the user tabs thru their choices to yellow rather than black? Thank you!!!!

Hi, is there a way to somehow clone records together ?? I'm not sure I'm using the correct terminology. I'm new to this. For example: I have a table that has Mbr A with different events that happen - I would like to be able to pull all of them in together and update other fields based on their...

Hi, I was wondering if there is a way to have a Name field (which is the relationship between the 2 other subforms) to change in all 3 locations if someone changes it in the initial form? Thank you

Hi, I'm trying to do an import from excel to access. I created a saved import and everything works with the exception of 1 field. I've defined it as a text field in both excel and access but if the field has for example 1234567B it won't import but if it's all numbers it will? Am I doing...

hi, can someone please help me? I've tried attaching a sample now a couple of times but it keeps failing so I hope this zipped attempt will work. Here's what happens: each month we receive data and it is appended into a table now in access. Once the new data is in there it needs to be compared...

Can anyone please help? I have a Booking Qtr field that if the [ActivityDate] is <2/1/2007 then it should using a Calendar year otherwise it should be using : Format(DateAdd("m",11[ActivityDate]),"yyyy - q") for example ActivityDate = 1/1/2006 the field should report 2006-1 ActivityDate =...