Recent content by Menes

Paul, My apologies, I mis-understood what you meant. Thanks for the code. I've put it in now and it does do something. When I click on it to bring up the form it just brings up a blank form. By this I mean just a grey coloured square with nothing on it all. I'm not sure why this is. Is it...

What I'm hoping to do is as follows just using one example: Button 1 - The form opens and data can be entered. Button 2 - The form opens and no edits can be made. Ignoring the visible part for the moment, this is the most important thing that I want to get right is how to lock/unlock the...

Hi all, I've designed a form in access and want to use it multiple times in Access otherwise I would have to create the same form at least 4/5 times so I would like to do is when the control/button to open the form is used, it applies different controls about what can be done. For example...

I've played about with this now and still seem to be missing some key command. If I take the first part of the filter the section: Private Function BuildFilter() As Variant Dim varWhere As Variant Dim varItem As Variant Dim intIndex As Integer varWhere = Null ' Main filter...

PeterF, Many thanks for this and sorry I haven't posted a reply in thanks. I've adjusted the code now and it's almost there. What the form is doing now though is only running the query using the category and so brings everything based on that and ignores the initial dataset request meaning...

I've created a form that allows me to select the email addresses that I want from the database based on the dataset that the customers has signed up for. I now need to put another filter on this so that as well selecting which dataset the customer has signed up, but it also selects the type of...

Struggling with creating a search function on a form using checkboxes. I'm trying to create a form where I can tick the boxes for datasets, for example, 1 and 3 out of 5 and the query will return anyone in the database who has those two ticked, whether it is just one of them or both or them...

Bob, Thanks for you help. You are indeed right in that it is an issue with the autonumber. Where I've put [ID] [int] IDENTITY(1,1)NOTNULL, it throws up the error on this. If I recreate the table with out the autonumber it works perfectly. I was planning on using this as the primary key by having...

Sorry Bob I missed your previous reply while I was posting. Despite having the default value set it still throws up the same ODBC error.

Thanks Bob. As this is the start of the project and still setting it up I just deleted the table and recreated it as suggested. I've put the create script that was used below however I'm still getting the problem with access having no default value pulled through when I link the table. Thanks...

Thanks a lot for that. I've set them to not allow NULL anymore and put a default value of 0 in "Default value or binding" in SQL however when the I make the link it doesn't pull the default value through and access won't let me make the change as "This property can't be modified in linked...

Hi all. Having a bit of a problem with a form in Access. I have the table setup in SQL and have linked in Access via an ODBC. I create a form using the fields to enter the data into however I'm getting errors when I use it that says: ODBC call failed [Microsoft][ODBC SQL Server Driver][SQL...

Currently have an Access database that we use to keep track of all our contacts which we pull the email address from when send out emails. We used to use Lotus Notes but have since migrated to Outlook 2007. Currently have Access 2003 but we are either going to Access 2007 or 2010 (not been...

Hopfully this will explain a bit more as to what I'm trying to do. I had to use printscreen and just paste as a picture as no matter what I did I could get the file small enough using winzip to put the actual database on here so you could see it. What I'm trying to do, is in this section of the...

I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help. I have a database that has been created by someone who has now left the company and it needs a little work done to it. The ideal thing...