Search results

Good morning, I think i'm snow blind on this and can't see to figure this out today... I have a workbook that has my master project list: EE - Projects I have the data stored in a table here. I have a separate workbooks to calculate expenses and timecards: EE - Timecards I enter my data in a...

Hello, I've been working on a project that incorporates Subcontractors with a State, a region (that i define by county) and then by City. My goal is to enter information about a subcontractor, select a state and a city. Then i want to be able to query subcontractors by state/region/city. I'm...

I'm so close, I think! haha I'm running Access 2016 on a Windows 7 machine. I'm working on a project that incorporates subcontractors and their respective scopes of work. I have built my join table, developed the 'subcontractor' main form,and insert the 'scope' subform onto the main form...

Access 2013 Development machine: windows 7 x64 Operating machine: windows 10 x64, access run-time (20xx?) Hello all, I've been searching and reading threads about creating and distributing split databases as a prepare to distribute mine. Nearly all of the threads I've been reading are geared...

Good morning folks, I've come across a problem that doesn't make sense to me. I have a form with a combo box on it. Each time the combo box is used or the form is moved to another record it triggers an event to update the text boxes. I get the information for the text boxes from a query...

Forum, Access 2013 windows 7 I am working with fueling up cars. I have a table tblFuelEntry in which data associated with fueling up a car is entered. Information such as Fuel date/time, tankMiles, Gallons, CarID, GasStationID are all entered. In my qryMPG I calculate the MPG for each fill...

Hello Forum, I have been having a little bit of an issue with a query crashing. I'm using a touch of VBA to run the operation so have landed in this forum but the query forum might be just as appropriate. I have a form made to help query a database in a variety of ways. One of those is...

Good afternoon Windows 7 Access 2013 I've been trying to work up a where clause that is generated by a button click event on a report. The workflow that i'm trying to obtain is as follows: 1) A report is run to determine the remaining work orders that need to be processed. 2) A button that is...

Windows 7 Access 2013 64bit Hi all, I have a product that i compiled to a accde but my machine is a 64 bit machine. My friend whom I'm sharing with has a 32 bit machine but will run the product in a run-time environment. First of all will this work? Second, what happened to the packaging...

Windows vista access 2007 I've hitting a wall here. I'm populating a report with a query which pulls criteria from a form. When the 'run' button is pressed it opens the report, running the query, to filter the data. What i'm attempting (and it works if there is data present). The data is...

Windows vista Access 2007 I can't seem to figure out how to test a combo box null value. I try: If IsNull(Me.cboManufacturer) Then MsgBox ("Please select category") Else DoCmd.OpenReport "rptItemCategory", acViewPreview End If This works if the combo box IS NOT NULL, but if null it...

Hello, Access 2007 Windows Vista I have a DB where i keep track of family heirlooms and valuables. As part of that i've allowed for the incorporation of images, although not every item has a picture but some items have multiple images. Because i only have the need to see one image i have...

Access 2007 Windows Vista GOAL: Display linked images in image control, and to ultimately to export reports to pdf to share with family by email or to print ERROR: “There isn’t enough free memory to update the display. Close unneeded programs and try again.” I’ve created a DB for family...

Was wondering if anyone does any genealogy? I have been fiddling with it off and on for a year or so. I think it's fun, but never ending!! But the history behind it all is fascinating.

Access 2007 Windows Vista Norton Anti-virus A week ago my norton anti-virus account ran out. I know, I know it's bad to have those things lapse. But, when it lapsed and i tried to open an Access DB it would really struggle. Many times it would time out and cause access to go non-responsive. I...

Windows Vista Access 2007 I have added a button to a form that would delete a record. This works just fine. I would like to add a confirmation that this is something that i'd like to do. I'm not sure if this is goes in the form forum or the or the vba forum? Thanks for any pointers. rob

Access 2007 Windows Vista I'm working on creating a DB that will help keep track of the family heirlooms in our family. I've built it around each of the 'items.' My question arises around the original 'ownership' and the current 'steward' for each of the items. The owner and steward would...

Good morning all, Windows Vista Access 2007 Yesterday I put together a small accdb file. On my last form I clicked the subform wizard and i get this thrown at me (see attachment). I had been using the subform wizard on a couple other forms and worked fine. I opened up a old 2003 file of mine...

Hello all Access 2007 Windows Vista I'm opening a pdf file that is external to the database and should always be located in the same directory. I have found the code that will open the file with a click event. Private Sub btnFile_Click() 'use command button to open pdf file 'need to get path...

Good afternoon~ Access 2007, windows vista I'm trying to understand how i can get nested subforms to work. I have a main form with a subform that is based on a many to many relationship. This subform is working. I would now like to nest another subform that would be based on a one to many...