Search results

I have a form with numerous command buttons that open various folders external to the database. I am looking at creating a folder to store recommendations against a certain serial number item. What i would like to do is have a check box that indicates "checked" when new data is placed in the...

i have a combo box that quires a table which is linked to an excel spreadsheet external to the database. It has a column that is labeled tail number. this column has numerous duplicate entries that I would like to remove so the combo box only displays one of each entry. I have tried...

Good Evening all, I have a form which as a textbox named "Core Serial Number" I have a folder that contains two excel spreadsheets, with the folder name, and the excel spreadsheet name that same as the core serial number displayed in the text box. e.g. Core Serial Number Displayed...

Good Evening, I have an access 2010 database that looks after all the engine data for a fleet of engines. Each engine has a unique serial number and that serial number is displayed in a test box on a form using a search function. Each engine serial number has a corresponding excel...

good morning, I have a form that allows me to update entries in a table. When I select the line I need to update and hit the "edit" button I get a run time error '2164' You cant disable a control while it has the focus. when I debug the line in the code that is highlighted yellow is...

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...

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...

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...

Good Afternoon All, I would like to create a form that allows me to search for a folder on my desk top, then once located i can transfer that file to a specific location on another drive, Similar to the Browse / upload function you see on many applications. I am using Access 2003. Is this...

Good evening all, I am trying to create a user log in form that will restrict people from accessing a certain form in my database. This log in form would require the user to enter a user name and password to gain access to the other part of the database. I have found previous posts on this but...

Good Afternoon, I have a access 2003 database, and i am wondering if i can't setup a search function in a form that will open a file in windows explorer? What i would like to do is have a test box that i enter in a number for example: 1234 then have a button named "Search" hit that button and...

Good Evening, I have a log in table that counts every time a user logs onto the database. Each time a user logs in it adds another entry to a table. I have built a query to display the user name and date of log in so I could display this information in a report. The report is now getting...

Good Evening, I am very new to access and I am wondering is there a way that I can have a popup box appear when I ask to produce a report and I can type in a parameter of my choice and it will produce a report based around that parameter? I have a table that is directly linked to an excel...

Good Evening All, I have made a basic form and use it a log on screen. This requires the user to in put a user name and a password before gaining access to the main database. The background to the form is a table where the users details are entered including the i enter the user name and...

Good Evening All, I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database. Is there a way I can add a counter to see how many times...

Good Morning All, I have an excel spread sheet that is linked into access 2003 via a table. This spread sheet is updated by personnel in another location and I have to run a weekly report on engines stored in that table that are below a certain performance level. The column heading is MGT...

Good Morning Everyone, I have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the...

Good Evening All, I have a table that is linked into access 2003. This table is updated by personnel in another location and I have to run a weekly report on engines that are below a certain performance level. The column heading is MGT Margin and I have to list all of the engines that are...

I have 2 excel spread sheets that are directly linked to Access 2003. These two spread sheets are put through a query to enable the data from both of them to be displayed on one sub form located on a main form. There are columns in each spread sheet that contain hyperlinks. I have the text...

I have an excel table that has 16 coloums and 100 rows. in each cell is a number. I have used the =INDEX(MATCH..... formula to allow me to input a number corresponding to the first number in any of the columns (pressure) and using the first number of one of the rowns it corresponds to an...