Search results

I've been trying to help my sister with a database query. I need the query to count the records of a field and display a number for the records of the field. For instance, one field is [Genre] and the other is [Show]. The query needs to list the Genres along with the number of shows for each...

OMG. I fixed the problem kinda. Not sure why the midname on the one record wasn't dropping down to the first letter like the others, but I just added another search as OR for the full midname. ([Beaver A&D Waiver].MIDNAME=Left([Updated Table].MIDNAME,1) OR ([Beaver A&D...

I currently have a database that looks for record matches between two tables. It is looking for same FirstName, LastName, MidName, and DOB. Here is the query: SELECT [Beaver A&D Waiver].LASTNAME, [Beaver A&D Waiver].FIRSTNAME, [Beaver A&D Waiver].MIDNAME, [Beaver A&D Waiver].DOB, [Beaver A&D...

I'm glad it's working for you Matt. If you click the reply button at the top of the page you will have more post options. You will notice a paperclip by the smiley addin at the top. That will allow you to add file attachments. You do not get that option using quick reply.

I've attached a sample database that has 4 fields: ID(for autonumber), Credit, Debit, and TransactionDate. I created a form with two unbound text boxes formatted for short date. I created a total query calculation sum for credit, sum for debit, and the transactiondate with the criteria to look...

Hey matt. Have you tried creating a totals query using the credit, debit, and date fields. Change total to sum for credit and debit. You could then specify a date for the date criteria which should give you the debit sum and credit sum for the day you entered.

I have a similar issue and I haven't found a thread to answer so I thought I would post here. I have two fields. One field is [DepositAmount] and the other is [ExpenseAmount]. I have been able to use a query to get the sums of each, but how do I get the difference of the two. I tried...

I forgot to mention that your test form worked by deleting the command button and creating a new one. Did you have any macros or anything attached to the command button yet? If so, I would try deleting the command button as I did and making a new one and adding the code after you see that the...

The issue is your command button. Whatever command or how you created the command button is wrong. Typically, I use the add button option, click on the form, and then cancel so I'm just left with a default command button. I then set it to transparent and set the height and width. Then make...

I've not had much time to look at the database, but I tested original code from what I used with two buttons and it worked fine. I have a feeling the error is possibly related to the module code and Acess 2003. I'm going to work a little more with your example now to see if I can pinpoint the...

Glad I could help. I had an issue with the directions on the other site. Took me a while of reading through it before I found my mistakes.

Re: I did get it to work I'm attaching a sample. First create a module. Just copy the code from my module. Create a form. Add 3 pictures that will make up your regular button, highlighted button, and on press button. All 3 pictures need to be the same size and have the same name, but the end of...

From my research I've found that Access doesn't allow you to use different formatting options within a text box. The only way I've found so far is to use some third party options with RTF and html. Thank you for your replies.

I'm currently using Access 2007. Under "Database Tools" there is an option "Linked Table Manager". Just check the boxes of the tables you need to link, I normally click the "always prompt for new location", and then click okay. You will then be prompted to browse to the location of your...

Using your example, is there a way I can bold [FieldName] in ="I agree to pay a pre-set fee of " & [FieldName] & " per month."

Great solution. Is there any way I can bold or underline the control entry that is mixed in?

For some reason the location of my text changes in print preview. For example, the last word of one line may hop to the next line in print preview. This is a real pain because I have data that needs to fill in to the reports. For example, I have a sentence that says, "I agree to pay a pre-set...

Both computers are printing to the same network printer. The only difference is one PC is running Windows 7 and MS Access 2007 while the other is running Windows XP and Access Runtime 2007.

I have a continuous form that I use for addresses. The form is mostly grayscale. When I open it using Access Runtime I get darker colors closer to tans and browns which makes it very hard to read. I went back over the form and chose standard colors from the most basic color picker and I still...

I have an issue where my reports don't print the same in Access Runtime. At first it was a font issue because the PC running the runtime didn't have the font so I added the font and that issue went away. However, I have noticed other prints that don't have the same spacing. My print will be...