I have to run 2 SQL commands, This is what I came up with but I'm sure there is a cleaner way. It works but cleaner would be better! Thanks DS Private Sub...

I have a form with a subform. It has 2 listboxes on it. The first listbox selects records and puts them in the subform, the 2nd list shows the results of the...

I can't quie get the synatax for a between statement. Any help appreciated. Thanks DS If Me.D34 is between 29 and 31 Then Me.TxtDay = Me.D34 ...

I have a query where the user can enter two part numebrs and get all of the data between those two numbers. My question is; is ther a way to get all of the...

I'm about halfway through my first Access book, and it's all about how to get data _out_ of Access nicely -- Forms and Reports and all that. For my imaginary...

I'm trying to create a database for our non-profit that can be used to record demographic information recorded during intake. For the data we report to the...

Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number",...

I am a new user who his NOT an accountant or a Techie, and find this program VERY difficult. Problem: I have entered all of the relevant data in the "Time...

I am running a distributed application on a Windows 2003 server box. The app uses an Access DB and I am curious what, if any, file size limitations there are...

HI Group i am developing a Windows project where i need to display my RTF files on to crystal Reports can this be achieved Thanks in Advance Have a nice day

Hi, I am very new to coding in MS Access/ VB Code and I need help binding controls on a form to a table. Hence, now my controls are unbound. I've been trying...

When my organization updated from Windows 98 to Windows XP, our Access 97 Membership Files date of birth field changed. Some members now have birthdays in the...

I am new to access and am working with an existing form that has 2 fields one for a birthday and another for a spouses birthday. The problem is that the...

I have a table that has the Date of Birth field that is set as a text field that is formated 99/99/00;;_ I need to create a query that returns anyone whos...

Hi there everyone, My boss wants me to set up a client database in excel that lists all our clients, this would need to be able to notify us of clients...

Hello all. Here is what I did: 1) Set up a query with LName, FName, DOB, BirthMonth: Month(), and BirthDay: Day(). 2) Make a report based on this query...

I have used advice from previous threads to produce a birthday table listed on day and month numbers. I am now attempting to add criteria to a query to give...

I have an OLE object as a field. I have created a form where it is one of the fields. I would like the user to double click it and for paint brush to open. ...

I just installed a new Logitech 2.4 GHz mouse on my notebook. When I am in the db window (I haven't tried in other windows) and scroll up or down, the window...