Search results

I am reworking a DB to simplify maintenance for salesman if/when I leave this company. The intent is to consolidate three tables into one flat file (which will work just fine). However, I still need to be able use three cascading combo boxes to filter the search. My first combo box (cboBrand)...

I have decided to re-make a table and at the same time, remake the form. On the form, I will have three fields that will effectively help drill down to get the right data. Brand (John Deere, Kubota, etc.) Model (there are 20 different models in JD alone, as well as other brands) Model Desc...

I have a database that we have been using for about three years. The DB consists of a front-end and a back-end. I have about 30 users that share the front end using a shortcut. (Again, this has worked like a charm for three years). Each user has Acess Runtime installed on their computer. Just...

I have a form that is used I to display tractor purchase price information. To get to the particular tractor I want to look at, I have three combo boxes that help me find the tractor I want. The first box "Brand", displays a list of different tractor brands The second box "Model", displays the...

I have a combo field that, when changed will update the background color on itself and two other fields. The issue is that the colors dont change until I have gone to another record and then come back to the record I am working with. While this generally works, I would rather have the screen...

I have a split DB that I want need to copy and use in a different manner. The new use will be putting a version of the DB on indvidual laptops (sales) so they can use a price tool program. This will require copying the current FE and BE DB's to a new name - "blahblah-be - Sales" and "blahblah...

I have partially figured out how to record a username into a table used during logging into the database. I now want to get the contents of that field (LoginID) from the table (tblImagePath) in a textbox in another form. Can't I just reference the field using [table]![tblImagePath]![LoginD]

I have a query from which I want to pull only those records that have been updated in the last hour. In my file, I have a DateTime field (12/21/2016 9:18 AM). I would like the query to include this record and others if the time and date have changed within the last hour. I have read that using...

I have a formula that is not rounding correctly. Can someone figure out what I am missing? =IIf([FullCk]="-1",IIf([chkSDel]<>"-1",(Round(([TrkRate]+[TrkMU]+Nz([Rush$])+Nz([TotSurcharge])),4)),(Round(([trkRate]+Nz([Rush$])+Nz([TotSurcharge])),4)))) I have another textbox that is giving me a...

I have an module that exports data to a CSV. My problem is that the data comes out with double-quotes around all the fields. what parameter can I use to eliminate this from happening? Below is my code: DoCmd.TransferText acExportDelim, , "qryRFIDEIDLocation", "p:\rental man\FTPRM\RMUpload.csv", 1

In my form, I have a combobox (cboFind) that I use to lookup records and it works like it should. I needed to add another field to allow our users enter the Contract# and on my inquiry screen, I added another field allowing the user to look up records (in the same table) based on the Contract#...

I am working a "form" that will allow our users to do some simple onscreen calculations. (I am using Textboxes - I know, i know - for now this is the route I want to take) I have a Start Date = 7/2/2016 I have an End Date = 9/20/2016 Using =DateDiff("yyyy",[txtStart],[txtEnd]) - I get the...

I have a report that is based on a query. This query pull records that have been marked at "completed" Is there a way to show the date range of the resulting records.

I have a form into which I enter the number of minutes I spend supporting my users. On the report, I have a "total" field that I sum the time spent. Below is the formular I am using: =Round((Sum([TimeSpent])/60),2) Presently the result is showing 16.83 hours. How can I best show the .83 in...

In my database, I have a screen that users enter data into and once complete, they click a button to do a Print Preview. If all is good, they can click the print button and the report will print. It works fine on my computer, but all my users that are using the Access 2013 R/T and when they...

I have an export that I am running through Autoexec and while it is working really well coming out as an xls formatted file, I actually need it to come out as CSV. Being exported as a text file makes the file come out with "|" and "-" and "+". Ideas?

I have my automated export running via task manager and it is creating an Excel sheet. That is fine, but the real solution would be to have a comma delimited file. If I change the format to csv, it comes out with "formatting" instead of a comma delmited data. To those that have not seen...

I think i am getting too old for this, but I have a question that I cannot think of an answer to. As some of you might know, I am working on a form that I am using to calculate transportation costs. Initially, this was just a screen that I used Unbound fields and textboxes containing formulas...

I have 4 unbound fields that I use to enter Zones (range of Miles). the fields are cboZone1, cboZone2, cboZone4 and cboZone4. Most times the 2-4 fields will be blank and it is highly possible the zones will not be entered in any particular order. They will most likely be entered lowest first...

I have a form that is used to do onetime calculations that I need to print. The issue is my form is a bit wider than will fit on a portrait page and I need to print it landscape. I am using a Event Procedure presently to print the screen and it prints fine, except for the fact that it bleeds...