Search results

how to use delimiter to search multiple filters [using john big booty's db] I implemented John Big Booty's dynamic search (found here: http://www.access-programmers.co.uk/forums/showthread.php?t=188663) using Access 2007 a while back and was recently asked by one of my work team members to...

[SOLVED] In Report Grouping, how to first list the matching relationship, and then In Report Grouping, how to first list the matching relationship, and then sort others Ok as some background to this report: I have 5 Marketers, each with their own Partnership zone(PZ). They have Companies...

How to auto find “When’s the next biweekly date?” -Access 2007 Currently, I enter biweekly dates (always on a Tuesday, unless Tuesday is a holiday, then most likely Wednesday) that I’m to send my media releases out in a table. The form then pulls those dates for a combo box. I select the next...

[SOLVED] How to change Directory location in Albert Kallal's Word Merge program?? I’m using Albert Kallal’s word merge program and trying to tell the program to look up a certain location for the Word folder, instead of searching for it in the same location that the access file is location...

I should first mention I'm using Microsoft Office 2007 I've successfully implemented the Super Easy Mail Merge using filters. For those interested in how to use the filters, here's the code: Me.Refresh MergeAllWord ("select * from qryContactsMerge where " & Me.Filter)Everything works...

Hi everyone, As an FYI for anyone looking for this, here's my situation. I have some dates I needed to calculate in relation to the event date (for my horseblanket) and 3 of which MUST land on a Tuesday. For example I needed to know when to send out invitations for this event, I needed to set...

[SOLVED] How? Concatenate fields if Null/0 OR concatenate "these" fields instead if.. How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT null/0 Ok, I'm a bit stuck on figuring this out. In fact I don't even know how to word it to look for the solution since nothing...

Hey everyone, Something I've researched online and was unable to find a solution for. I played around with it and this is what worked for me: Combo box on continuous form should have the control source listed as the field on the form that will be updated. The Row Source, however, is a...

[Solved] Subform won't load from combo box selection--need to load so can add record. [Solved: Thank you to CJ London for his help :D] Hello everyone and HAPPY FRIDAY!!! I haven't found any solutions that work for me so I'm seeking help from you. Anything you can offer me is much appreciated...

I entered a function to hide the Access background so that only my pop-up shows to the user. Forms I created are pop-up and centered properties are set to yes. The DB file has been changed from tabbed to overlapping as well. I’d like to maximize those forms/reports and have the content center...

SOLVED--SEE BELOW TRAFFIC background of what I'm trying to accomplish: I have set-up a column in a query to count the amount of null values for each record. However, when a field has information and then is deleted, that field is now read as blank (or 0 value) instead of null and my count is...

This was driving me crazy until I figured out a simple solution. I figured if it drove me nuts there might be someone else who needs this info. Background: I have a survey in which people rate items from 1 to 10. I've set-up my report to calculate how many 1's in field 1, field 2 etc. and how...

I was provided code to allow Access to read multiple tags to allow access to certain command buttons within my database: Private Sub Form_Open(Cancel As Integer) Dim ctl As Control 'Users 1 and 7 have access to all buttons If UserAccessID = 1 Or UserAccessID = 7 Then For Each ctl In...

SOLVED--SEE BELOW TRAFFIC & & Hi everyone, I am trying to accomplish null values being changed to red in my report. I used the above quoted advices that I found through my searches, but the cells don't highlight unless the mouse is clicked on it. (whereas I was hoping they would...

I've created a query with intentions to only allow a record to show if it has a null value in any (or more than one) of 6 fields. I tried intering 'Is Null' in the or section of the query's design view, but I didn't receive the results I was looking for... does anyone know how to do this...

So it's my understanding that you cannot input more than one tag into a cmd button's properties. I came across the idea of setting up a table of parameters for the tag to direct to though. Does anyone know how to set that up or perhaps have a better solution?

[SOLVED--SEE BELOW TRAFFIC] I have a form in which only Users signed in with certian user access ID's can click on certian Command buttons on the form. Since there are 7 buttons on this one page, my if statements are growing very large. Does anyone know if there an easier/better way to...

[SOLVED--SEE BELOW TRAFFIC] I've created a report to list every record (1900 something total). This one main report is used to open my many querys (more than 50). In order to save myself from creating numerous reports I filter the records through my command button before opening the report...

Anyone know if there's a way to save all queried records with each as it's own individual pdfs instead of all merged into one?

I suppose I should have done this when I first registered lol. Short and sweet is I love to learn technical things. I don't have much of a memory so I learn mostly by cut & paste, but have gotten far with that and a little bit of common knowledge. I have managed access DB in the past, but...