Recent content by sdchris

I think I should be using AND instead of OR. Doh.

David, For some reason it filters correctly when I have one combo box selection, but when I have multiple combo box selections it displays all records. Dim strFilter As String If Not IsNull(Me.cboCountry.Column(1)) Then strFilter = strFilter & "[Country] = '" &...

I like the look of that code! I'm going to give it a go. Thanks, Chris

I have a question. If I want to filter a report based on 5 combo box entries, do I need to run an if statement to check for null values on each combo box? Or can I run an IIF statement within the where clauses to do nothing if null? This is the code I'm working with at the moment...

Bummer. I suppose I could go as is since the table I'm querying records from only has 5 entries. When I export to excel I can just replace the specific numbers with what I had listed in my combo box. If you think of an easy way to go about it, let me know!

Thank you, David. My problem is not in storing the data. I've got that down. It shows up as a number in the main table. My problem, which I didn't explain well, is displaying the contents of the 2nd column instead of the bound column (primary key numbers) in a generic query. I don't...

I searched and couldn't find a solution to this most likely easy problem. I'm sure someone out there smarter than I can help me out real quick. I have a combo box which queries a table and then stores said tables primary key field in a field for my main table. The table queried has two...

I just used this code in the On Current event: Private Sub Form_Current() If IsNull(ProjectNumber) Then ProjectNumber = DCount("ProjectYear", "ProjectInfo", "Year(Now())") + 1 End If End Sub Do you think this is acceptable?

I have a year field that automatically enters the current year when creating a new record. From there, I want my form to check the project number field to see if it is null, and if it is, count the duplicate amount of years and then add 1. For example, I create a new record. The code checks...

I was baffled so I got our IT department to help with the database. It looked like he wanted to punch me when I said we wanted to use access. I'll post the code that he used to implement these features when he brings me back our access database. Regards, Chris

Thanks for the replies. I tried out your code PBaldy, but it had a different result. Instead of incrementing the numbers, it kept them the same. I can get the number to increment with access and then concatenate that with the year, but I can't get the code right to read the year, find the...

I read through this thread and implemented a few features that were suggested by Pat. However, I'm still having trouble grasping how I can get the incrementing number to reset at the start of a new year. I would prefer for it to continue on each year, but my boss likes it to reset. What I...

Thank you, bob. :D This solved my problem and kept my sanity. I hope whoever runs into the same problem and does a search for movable finds this solution.

Currently my form displays in a maximized window. I'm trying to get the form to display in a window. The movable command is set to 'No'. Every time I set it to 'Yes' it instantly reverts back to no. Any help or suggestions is appreciated.