Search results

:confused: hi guys, I need some help please...... I have an access database which I downloaded from here: http://office.microsoft.com/en-gb/templates/CT101426031033.aspx?Origin=EC010223681033&CTT=6&av=ZAC Its the "Issue Database" This will do everything I want...but I would like to be...

The numbering would start at 01 and I want it to go up in ones every times a new document to add is selected. 01, 02, 03, 04 etc

I have a text box, in the box I manually add the next available number for example: 02 Is it possible to have something set up to automatically add the next available number? :confused:

I have a text box which is currently empty. What I would like to do is to have part of the text box filled in each time a new record is selected, the user would only then have to add the numbers, is this possible to do? The wording would be: FGA-GOSS- then the user enters in a number :)

Hi, I have used the: Code: <=[Please enter a date] in the Query Criteria field and then added: <= 01/04/09 in "Enter Paramter Value" Message says "Expression is typed incorrectly or it is too complec to be evaluated"

Yes they are in a date field, how can I set it up so as the user can add this info in the "Enter Paramater Value" in the report?

Hi, I want to be able to show dates which are previous and up to say April 09, what formula do I need to use? I am able to select a month by using "Like[Enter Month]" but I want to also show all previous months that are due...:confused:

This has worked for me. Thanks Kiwiman

Hi, I have copied a query and renamed it as I want a report to be selected by a specific criteria which is ready and working. I have copied a report and renamed it now what I want to do is to change the "field list" to display the new query so as the new report will pick up the criteria I have...

"Perhaps in your [Close Form] button you need to create and update query to update the original table with the edited data instead of the copy/paste append." Sorry to sound to thick but how would I do that?? :confused:

Some questions: Where is the record-to-be-copied coming from? - Coming from a table called "Table1 Main" Where is the record intended to be pasted to after edit? - dont know? what would I need to do for this? Where is your code instanced from? The [ Close Form ] button? or Where is the...

doco, I have added some screen shots, top and bottom of the form. I want the user to copy/duplicate the record which will be in Edit Mode and alter the parts they want to change.

The size of the DB is 3.33 MB too big. I have 4 forms in total, one which I use as a switchboard or menu page, the other three are forms one to add, one to edit and one to view. All forms are identical in layout. They all have unique id numbers. What I want to do is for someone to be able to...

ok thanks anyway I'm giving up as I don't know what I'm doing properly. maybe at some stage I will figure it out.

doco, the paste apend is in green, what other information should I give you?

I have On Click [Event Procedure] and this code: Private Sub Command462_Click() On Error GoTo Err_Command462_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, ...

Can someone please help me, I am not very clued up on Access. I want to create a duplicate record button on my main page, see attached. I have tried to use the wizard but when I click on the button nothing happens apart from the error "The command or action "Copy" is not available now" What am...

Anyone help?

Hi, I have a form with a text box and what I want to be able to do is when someone clicks on it I want it to open up into Microsoft outlook, is this possible? Then they can select someones name from the address book and the form is emailed to them. ;)