Search results

Hey, all! I'm using Access 2013 and trying to run a simple DELETE query on a table in another database, but because of attachment fields, the query errors out (Cannot reference a table with a multi-valued field using an IN clause that refers to another database). I would really love to keep the...

Hello, all! I have a question about how to deal with the loss of replication in Access. I will start by mentioning that I work for the government, and am limited to using Access 2013. No extra servers and no online connections – if only! I had previously chosen to use replication because...

Hi all, I am having difficulties working though this loop problem - for some reason, I am missing a vital concept! BACKGROUND I am trying to copy certain fields from one record to another using a command button on a form. In the OnClick event, I set a SQL string as a DAO recordset and then...

Hi all! I need to create a query and I’m not 100% certain how to make it. I have a query that shows the latest construction date for a Site and a table with two types (Type = 1 and Type = 2) of reclamation criteria, and a start date and end date for each criteria. I need a query to tell me...

Hi, all - I am trying to track my band's assets in a db and need a little nudge in the right direction! I want to be able to track how much money is owed by members for our assets. Usually one person will buy something for the band and then the rest of the members need to reimburse for their...

Hi all, I'm having trouble with a shell() command in my vba. I'm trying to call up the picture viewer showing the file of the photo I clicked on in a form. Everything is happening as expected - the file opens in Windows Photo Viewer, but it is minimized. I can open a picture fine from...

Hey all, hopefully this is a quick one! I have a query with fields: InspectionType (integer) RndInspecNum (integer) I have a table with fields : RndInspecNum (integer) 2 Year (Boolean) 5 Year (Boolean) Decennial (Boolean) and I would like to filter the query so that if InspectionType = 4...

Hi all, I have a pop-up modal form which is loaded (like 99% of my other forms) by a button on another form. Unlike all of my other forms, however, it doesn't load its background properly. If I drag the window off screen and back or shrink and resize, it does look right, so I guess maybe it...

I am about fed-up with the snapping behavior in Access 2010. I understand that 99% of the time it is great, but when I want to move objects like buttons around a form that has a table it is often a fight to keep them where I want them (not locked into a table cell). I am aware of the snap to...

Hey, I thought I would just check to see if anyone else has had this issue; it seems quite odd to me, and I'd love to know how to fix it. I have a combo box in a form which simply pulls a text field from a single table - approximately 100 values to choose from. On the After Update Event, there...

Hi, all - I have a one-to-many query which I would like to add a subquery to eliminate all but the TOP 1 of a field. Here is the SQL: SELECT QrySitesBatteries.SiteKey, QrySitesBatteries.SITEID, QrySitesBatteries.Battery FROM QrySitesBatteries WHERE...

Hi all! Quick question: I have a continuous subform with an unbound Concat textbox and would like to populate another field for each record with the results with a main form button onClick event. How do I accomplish this? Thanks for your assistance!

Hi, all; I have two tables: tblSITE and tblUSID (joined by SITEID) and I am trying to create a query which lists each site and the USID with the latest date in its ConstructionDate field (USID and ConstructionDate are both in tblUSID). If I omit the USID from the query and run a totals...

Hi all! I have a "dashboard" form in my DB which has a couple of subforms with DCount/DMax textboxes giving various counts from queries. I have found that the text boxes have ridiculously slowed down the load time, and I am looking for an alternative. What exactly is the alternative? I’ve...

Hello, all! I am trying to develop a (fairly) simple DB to use with my band, and would love to automate the creation of setlists to print out for the band for when we perform. I’m having some difficulties figuring out how to go about this. :-/ SO FAR, I’ve created a table for all the songs...

Hello! I was hoping to get a little assistance with a problem I am having. This is the table I am working with: tblInspection InspectID - autonumber field -PK InspectionType - long integer - either 2 Year, 5 Year, 10 Year, 20 Year... as well as some other irrelevant (for this question) types...

Hi all! I am working on an inspection DB at work and I am having difficulty figuring out the best way to deal with dates for future inspections and to be able to have the data easily queried to find out what inspections are due. In a nutshell: 1. sites need to be inspected 2, 5, 10 and every...

Hey, all! I'm a bit stumped with a development question - I am doing an inspection DB and there are a few different kinds of inspections (some with their own tables). Most of these types of inspections have a "re-inspect date" which will be used for alerts and reporting processes. What I am...

Hello! I have been struggling to make this happen, to no avail. Any guidance would be appreciated! I am trying to make an on-click event that would open a form showing the last inspection done on a site. Unfortunately, I cannot even first create a dlookup function to use, so I haven't even...

Hi, all! I have found and inserted a module to center text vertically (don't even get me started about how that isn't just a part of Access :confused:), and it is called VerticallyCenter. The forum I found it on said to use it as: VerticallyCenter Me.YourLabelControlName But I have a metric...