Search results

Greetings all, I have a question to see the best way to go about this. I thought I may have found the answer through a different page on here, but lost the link to it (stupid phone) and now I can't remember where I saw it at. I have a table (tblMain) that has on a daily about 700 to 1000 records...

Good evening, I have an excel spreadsheet that I import to a table that has item numbers, some of the item numbers will contain an underscore in them. When the spreadsheet gets imported it creates a table with import errors which says conversion error and it happens on the ones with the...

Hello all, I have a question, I am looking for a simple way to add blank rows to a report when it opens up. If I have a report that opens up and only has lets say 10 rows, but when printing I would like it to display at least 35 rows as some of the other reports being printed from the same...

Greetings all, Been a while since I have posted on here, but I have another issue with filtering a report. I have 2 drop downs to filter a report on, one is to select a date, the other is to select a truck number. I can get the truck number one (which is short text) to finally work, but when I...

Greetings all, Been a while since I have needed some help, sadly that time has come again haha. So here is my issue this time. I have a form that I have created a link from one of the fields called Product, I have another form that has a combo box on it called cboProduct. What I would like to do...

So I have run into yet another fun issue with my database. I have 3 different forms that I utilize the Audit Trail with, this part is working fine finally. I now am running into an issue where on my forms I want to move the records to a Deleted Table to have a better viewing of what was on the...

Greetings all again, I have a form with an unbound subform as I don't want to select just one record in my subform when I am searching. What I have is on the form is a search record box which allows the user to type in the record and go to that record. This works fine, what I am trying to do now...

So basically I am running into an issue where I have a form to track expenses. When the form loads, instead of having New in my Expense ID field as being a new record, it loads up to the new Auto Number already generated. Issue I have is when the form loads, it creates the record in the table...

Greetings all, I have a question maybe could get some assistance on. I have a subform that will display parts available based on specific vehicle information (Year/Make/Model) this all works fine. What I am trying to do is when lets say I add more than one part to the subform but then realize I...

Name is confusing sorry, basically I have a query that takes a cost price and multiplies it by the quantity. I then pass that total to an unbound field that then updates a bound field. Yes I know not to store calculated fields in a table, but it seems harder to not store the "sale" of the part...

Hey all, I am having an issue I have an append query that is to add new records to a table. The query is tied to a button that checks to see if a checkbox is checked and if so to run the append query. The problem is when I check the box and then click my Save button nothing is copied over, but...

Hello everyone, I am looking at the best way to open a form built from a table. In my case a customers table. What I would like to do is on a button it opens a customers form displaying the first 20 or so customers, then at the bottom have a Next 20 button to display the next 20 customers. I...

Greetings all, I am looking to see if this is even a possibility or not. I have a drop down list for different products. I also have images on a products form where parts are entered into the database. Is there a way that when you open the drop down to select a product, as you hover over the...

Hey everyone, I am need of help once again. Working on a simple expense tracker database. On the form I have two different comboboxes that based on certain selections with make some textfields visible. On the first combobox (ExpType) there are 3 different options within the list that if selected...

Sorry for the title, not sure the best way to word it. So my question is for all you experts, (thank you all by the way for everything, ya'll have helped a LOT) I have a two inventory tables with forms (well subforms on a mainform) that have a part cost associated with them, and a selling price...

Ok, I am having a hard time getting this to work. I have seen numerous posts all over the Internet stating to use the below code. However when I place this code onto the Double click event, it opens to a blank record, but if I double click it again while the one form is still open, it will then...

Hey all, Ok, I am stuck again of course lol. I have my forms and reports working, however when I click on my button to load the report, the values of the fields from the form are updated to the report unless I save the record then go back to the record. I am trying to load all the values to the...

Hey all, I am trying to create a button to clear the entire form in case and not let the data get saved. I have a main form (frmOrders) with two subforms (fsubOrderDetails and fsubOtherInvoicedetails) What I am wanting to is be able to clear all data on the forms and subforms making sure the...

Hey all, If this is posted somewhere already then my apologies, if you could point me to that thread then that'd be great as well. If not then if anyone could give some suggestions I'd appreciate it. What I am wanting to do is I have an order form for doing a work order. I finally got everything...

So I've been seeing this site a lot for help with Access and from the vast community here. I have even benefited from some of the posts. So just wanted to say hello and thank you all for the help I've received so far. I'm fairly new to using Access, but understand the basics of it all. I'm still...