Search results

suggest that you have a form with a text box where you input the date that you want to work off. Call the text box txtDate and the Form DateToday and then in the query you would have: NewDate: [Forms]![DateToday]![txtDate] + 2 + [Number of Days field] HTH

To look at the last digit then you need the formula right([SlotNumberFieldName],1) This will show the last number for you to then assign whatever it is that you want. HTH

The easiest way is to send the details out as an email and then either maualy update the record or get access to read the email inbox and update from that. Problem with sending data out and then getting it back in automaticaly is that invariably the data has to be in predetermined positions...

Presuming that you want to show all records from the previous month so: SELECT * FROM MyTable WHERE [StartDateFieldName] = format("01/" & format(dateadd('m',-1,Now()),"mm/yy"),"dd/mm/yy"); HTH

View this post: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34990 HTH

Presume that you have something in your query like: Field [County] =Forms![MyForm]![cmbBox1] Try =Iif(Forms![MyForm]![cmbBox1]="ALL",[County],Forms![MyForm]![cmbBox1]) Where [County] is the name of the field in the query HTH

Just an idea but how about making your combobox contain 2 columns. The first is the one seen by the user with the list of counties and also with the choice ALL, the second has the counties but * for all ForUser, Hidden ALL * Hampshire Hampshire etc...

Few things which I am not sure but think that they may cause problems. You are using with and then running normal lines of code within the with statement. Don't think you can do that, though am sure that someone else will confirm one way or another. In all of your trials you missed out the...

Sorry can't help but can confirm that Acc97 on 2000 is not a healthy app! My personal gripe is on graphical reports where the graphs are not showing the true data (even when the graph is forced by code to update!) Good luck though suggest keeping the same OS and Office products together as...

Look at this site: http://www.daneprairie.com Download the software and use it for free but you will get a page tagged on to the back of the report. It also gives you the code to name your files etc. HTH

look at this pdf writer: http://www.daneprairie.com

If the image is in the details section of the report, click on the details header bar and get the properties box to show. Now select Events and OnFormat. Click the three dot button and select code. You should then be taken to the VBA page and see something like: Private Sub...

When you open a 97 db in 2k it tries to convert it automaticaly but it says that I do not have the permission to do so and it drops out. Therefore I cannot convert it. What do I need to do?

See if this (when amended to fit your table / field names) works. SELECT * FROM [TableName] WHERE ([IDFieldName] = "I077" AND [CostFieldName]=0.00); HTH

Am trying to convert a database from 97 to 2k but when I open it in 2k it gives an error message saying that I do not have permission to change it. I can open it and build edit etc in 97. What do I need to do? Thanks in advance

Create a copy of the query that is showing the totals by group In the design grid you will have Resp Group and Sum of RespGroup Delete all fields EXCEPT SumofRespGroup Now you should have one field showing one item which is the grand total HTH

In the criteria of the specified field in the query type =[Forms]![NameOfForm]![ControlName] So eg: You have a field in your query called Surname. On the selection form (ReportSelect) you have a listbox called lstSurname. In the criteria of the field Surname in the query design grid...

DoCmd.Rename "NewNameHere", acForm, "Form1" NOTE: Form1 must be closed to be able to rename it HTH

Check that you have the relevant reference library loaded. Think that it is either (for Acc2k) DAO3.6 or Access9. To check open a module and the Editor window will open and then click on Tools / References. HTH

Haven't been able to find a sumif function, but .... 1/ Create a new textbox in the details section, call it txtInvHid, and set the Visible property to NO. 2/ Set the Control source as =Iif(OverdueField = True, [Invoice Amount],0) This ought to show only the values that will be summed at the...