Search results

HI, Not sure but I think your problem may be the 2 field primary key. When you are saving the value to field 2 are you also saving the correct value to field 1? I never use 2 field primary keys because I find them too confusing and liable to unexpected problems. I would add a field which I...

Hi again, panic over. I have just discovered that you have to specify a default condition before it will apply the others. As it shows a default setting at the top of the page I assumed that was already done, but if you actually specify the default then it applies all the conditional...

Hi I am trying to use the conditional formatting button in the formatting menu of Access 2007. Putting the format on is similar to earlier versions, and I can do this. However it doesn't seem to work. What I am trying to do is colour a field if it's value is before today. When I put in the...

Thanks for the reply Gemma. I have now managed to structure my querys so they will work. I can check the value of a code is less than 2 rather than the field doesn't = a text value, or equals 2 text values. I also found the table link I thought I needed wasn't correct as I was looking at the...

Hi, I have had a response from SAGE which wasn't very helpful. Here it is. The ODBC driver for Sage Line 50/Instant Accounts is intended for use with the Sage Report Designer, and therefore support is only available up to the point of connection to the Sage company data set. The Specific SQL...

HI. I have written an access 2007 database which looks at SAGE files, and produces custom reports from the SAGE data. I need to distribute this database to several PC's at my clients site. I can produce the deployment package using the wizard, which I have to say was really easy and worked...

HI Gemma, Thanks for the reply, I'm sure it's not that, I used the QBE grid to create the SQL, just a nice simple select criteria, so I'm sure it's something to do with how SAGE reads the query rather than how access writes it. Thanks anyway. Sue

HI All. I am having trouble with filtering and linkoing data from SAGE to my access database where I want to produce some clever reports. I have posted on the sage forum, but though I might get more help here, as I have in the past. Here is my problem. I am trying to create a report in Acces...

HI . No the create form from wizard is still there, but access 2007, like all the 2007 office programs looks completely different. It now has a ribbon, rather than menus and it has got lots of new tools to do things quickly. I tend to use these to do the rough production of forms etc, then...

Thanks, Thats nearly there, and will certainly make my life easier. For info In Access 2007 the format menu on the ribbon appears when you are in layout mode, or when you are in design mode there is no format menu, the formatting is there on the ribbon, and the autoformat is on the right hand...

Hi Chris I have had the same problem. I solved it in the end by making the record source for my second combo box show only one column. That is: My second combo box gave department after fist choosing a person in the first combo box. Of course if the next record chose a different contact...

HI Bob, I think I am getting a better picture now. Do you run this query and it updates for all customers, or do you run it once for each customer. If it updates all customers at the same time, maybe you could save the last run date in a table of it's own and put this table in the record...

If I understand correctly you are looking at a customers record, and on that record is a button that runs a query. You want to show the date that query was last run beside the button. If that date is saved in the customers record in the tables then you should just be able to show that field as a...

HI, I'm expereinced in Access from 97 to 2003, but just starting the change to 2007. Generally it seems fine, just the usual "where have they put that command" you always get with a new version. I want to set up a form template, using my prefered fonts, sizes etc, as I quite like the create...

Hi. I have done this sort of thing. I have a table where I want the record to turn yellow if is is a subassembly. I have achieved this by doing conditional formatting on each field, and using "expression is" as a condition rather than "field value is". You would then use the expression Nuns...

Hi Les, The maximum number you can have in an integer is 32,767 so putting in 57069 gives an overflow because the number is just to big. Change intnum to be dimentioned as long and you can go up to 2,147,483,647 which should last you a while! Sue

Hi Les, I'll have a quick look. Which form should I be looking at? Sue

Hi Les, Glad to help. I have always used the format I showed you, I didn't even know about the other one, so you should be fine to stick with the one I use. Good luck with the rest of it. Sue

Hi Les, I think I've fixed it. The problem was with your openform command. It didn't seem to like you setting a filter after the openform. I have used the folowing code instead and it seems fine If Me.txtCaseType = "MED" Then DoCmd.OpenForm "frmMEDProspects", ...

HI, That doesn't sound good! I would guess your query has a problem. Try running it by opening the query and see if there are any error messages there. If you like post a zip file of your database and I'll have a look, can't come up with any answers from what's in your post so far. Sue