Search results

I've seen this question asked in multiple places but do not understand the answers (yet). I haven't worked with the ribbon and XML before so I need some assistance. I'm able to turn off the navigation panel and the ribbon completely which gives the user a nice, empty screen. However, when...

It is downloadable from the reference library and is a GREAT resource for doing a fuzzy match. My question is how can I implement it take a field on a record and have it return ONLY 1 record from another table that is the best match? Simil will compare 2 strings. I want to compare one sting to...

I have a multiple record form that displays fine. However, on the left hand side there is a column that when a record is selected, an arrow appears there. I don't know what this is called in order to suppress it. Help please?

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working. What am I doing wrong? <code> DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit...

I created a form to enter the lookup data and build the SQL string to create a recordset in VBA that is a subset of the original data. Using the Form wizard I created a form that displays ALL of the records in that original table (actually a QUERY). What I want to do is open this second form but...

I have a query where I want to check if a value of one field exists in another table. If it does, I want to set a value to True and if not set it to False. What is the easiest way to do this? Thanks.

Access 2007. I can run the report for last month and with the VBA code outputting it directly to PDF and it works. When I run it for this month, I get an error 2501. This report has been running for months with no issues. When I run it for this month and preview the output, I can export it...

I have found multiple ways of calculating the week of a month for a given date. Now, I want to reverse it, i.e. given a month and week and day of week calculate the date. Somewhat stumped here. Note that in week 1 and last week, there will often be days with no value. Thanks.

I want to create a report where the group header can change based on VBA (similar to what I can do with a page header or report header). What I am looking to do is create a monthly report on each page. The data is daily and I want to have 7 columns going across repeated 4-5 times a month on...

First time I've tried creating a chart and obviously I'm missing something... I have a query that lists for a multiple people and months, 2 values... For example: Joe 01/2013 25 45 Joe 02/2013 10 70 Sam 01/2013 37 40 Sam 02/2013 79 23 When I tried using the wizard, it...

I have 2 tables. One has employee info and the second has time data based on thresholds reached in the employee info. Obviously, a basic join will bring in all of the threshold records. How do I get it to only pull in the one that satisfies the threshold condition?

Going back a ways but I remember I had placed a hidden field somewhere on a report in order to perform a calculation to be used elsewhere in the report... Now, it is causing an error as I have changed how the report is generated but I no longer remember where that field was... Anybody have any...

What I am looking to do is to walk through a DB that has a field on each record as to what conditions to check for. If the conditions are true, keep the record. If false, delete the record. The contents of the field that has the conditions do change from record to record. I want to build an...

I have VBA code (Access 2007) that first copies a file using UNC convention and later uses a MergePDF procedure to consolidate that initial copied file with the generated PDFs... On my PC, Windows 7 Professional 32-bit, it works fine... On other people's PCs, the FileCopy does not generate any...

I hope I can explain this clearly... I have a query that based on certain codes in a record does multiple joins to pull in other codes... I want the query (based on these pulled in codes) to do a lookup in another table to extract 1 field that has a description... Can I do this in one...

I'm using Access 2007 and my DB was 2000 format... I just updated it to 2007 format... Now, the following statement in one of my reports has stopped working: DoCmd.OutputTo acOutputReport, "Encounters by Location and Department - ALL", acFormatPDF, XFile There is no error message or...

I see many people have had this same issue in the past but I haven't been able to find a solution... Using Access 2007, how can I link (or import) Foxpro tables that I can access in Excel using OLE DB??? Thanks...