Search results

@DennisOJensen. Thank you for looking at the database im currently working on. I have tried to use the database but some of the command buttons do nothing. I can not add or update data in the table via the form.

@gemma-the-husky. If I bound the form to the table, then how do I make the command buttons, to add, update, clear, and delete data from the table?

@gemma-the-husky I have attached the access database im working on at the moment in a previous post. I will have to look at how to bound a to a table, and see if that will allow me to edit, add, delete rows from the table via the form fields.

Thanks @DennisOJensen I have attached the database as im working on it now. Just some of the information and language you and @Markk are using I haven't heard before. I have been watching youtube videos, trawling through the forums getting information and finding new ways to do things, as I...

@Markk I have added you code and I keep getting "Too few parameters. Expected 8" error message. When I debug the following line is highlighted. .Execute dbFailOnError Can you please help with this. @DennisOJensen I added you code and nothing happens when I try to update a row in...

Thanks @Markk and @DennisOJensen. This is all a bit over my head, as im really new to this. I am unsure where to insert this code you have provided. I will start having a play around with it all, but any advice would be most appreciated.

Thanks fro the reply @DennisOJensen. So not being really fluent in all this code writing. I just replace the yellow highlighted area with what you have provided? The Day bit is a date, but I have it as a txt field, is that going to cause issues or will it be ok to leave it like that?

Thanks for picking up the spelling mistake @DennisOJensen. I have fixed that up and still have the same issue. When I debug the code all of this is highlighted yellow...... CurrentDb.Execute "UPDATE tbllessonslearned " & _ " SET ID=" & Me.txtID & _ ", Aircraft='" & Me.cboAircraft & "'" & _ "...

Good Afternoon, I have been developing a form that will allow me to input, edit and delete data in a table. I have the input, delete, clear, and close command buttons working ok, but I am having trouble getting the edit function to work. What happens is that I highlight the line in...

I browsed the location and have the folder and all sub folder locations listed in the trusted sites. I reverted the database back to a 2002-2003 under the default file format and the printing commands buttons work. Would be good though if it worked as a 2013 database

Yes, the forms are populated with data, and the report runs and displays the selected data, when I hit the print button I get the error message.....very strange. It all worked fine when I was running access 2003, but since running in access 2013, I have had this issue

I have just tried the other print options and none of them work. I have a print button on a few forms and I get a "the PrintOut action was cancelled. I have not setup access2013.with a default printer. How do I do that? I would also like users to be able to print from their default printers

When I open that database now I get a security warning that "we can't verify who created this file" When I click yes the database opens ok

Yes the location of the database is in a trusted location, with enable Marcos and active x settings checked without restrictions

This is the code behind the command button. To produce the code I used the wizard attached to making the command button; Report Operations, Print Report, select report name, name the button and click finish.. Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim...

Good Evening All, I have just upgraded to access 2013 from access 2003, and I can no longer print my reports from the form using the command buttons I made. I have a simple forma with 6 command buttons that each run separate query to produce a report as requested by the user. I have a...

I have made the table with the link to the master workbook. Since i am very new to access, could you please expand on the query, select statement, select query and append query. Thank you very much

Yes the master workbook keeps the same name. I'm using Access 2013 Can access build effective graphs for the transferred data?

Thank you for your response Rx. The master workbook is updated daily by data from another excel workbook that I don't have access to. I then have to cut and paste each row with the corresponding serial number into its own workbook. (The 58 other workbooks) eg Eng SN 123 corresponds to workbook...

Good Evening All, I currently have a master workbook, that has data uploaded to it every day from another location. The data in the master workbook then has to be transferred manually to 58 other workbooks located in their own folders. (cut and paste) I have used a {=INDEX formula in each cell...