Search results

I've got a call tracking system. I've got one table, Calls, that has a field Quote Number. In a separate table, Notes, I've got the field Quote Number and the field Notes. It's in a separate table because each Quote Number can have more than one Notes. The problem is that every entry in Calls...

I couldn't find any code there, but I found this someplace else and was hoping I could adapt it: <LI class=codeLI>Option Compare Database <LI class=codeLI> <LI class=codeLI>Private Sub cboChargeCode_NotInList(NewData As String, Response As Integer) <LI class=codeLI>Dim strSQL As String <LI...

I'm having trouble understanding one thing. On the People tab on the form there is a drop-down for People/Organization. The choices on the menu are all the name records in the database so far. There is no way to enter a new People/Organization when I'm logging a new call. Does that make sense?

Wow. Thank you so much!

The notes were designed as part of the Tracking table at first but then I realized it would be good to split it off into two tables. I created the second table but didn't delete the field off the first one...just in case. The Notes field on the Tracking table is irrelevant.

Ok I zipped it and I hope I did it right. Let me know if I didn't...

Ok I can do that. But is there a way to insert QuoteNum into both databases without having the user type it twice?

I've got two databases. The main one has a field, QuoteNum. The child one has a field, QuoteNum and a field, Notes. There can be more than one Notes for each QuoteNum which is why I split it into another table. I have a form from which the user enters the data. Is there a way to get the form...

Never mind - I figured it out. I can't use the # symbol in my name. Sorry about that...

Thanks! I didn't even think of that. I'm getting a syntax error with it though: INSERT INTO QuoteNotes (Quote#, Notes) SELECT Quote#, Notes FROM Tracking; It's in the INSERT INTO part. Any ideas? I looked at the help and it looks like I'm doing it right...

I've got a database with two fields on it - quote number and notes - that I want to split into its own table. Is there any way to move the data over so I don't have to copy/paste a hundred times? Many thanks.

Thank you all for these suggestions. I'll look through them and I'm sure I'll find exactly what I need.

Hi. I'm trying to teach myself Access from a systems development-type point of view. Can anybody recommend any books I might start with? I've pretty much exhausted the online tutorials and they really aren't going into the depth that I have in mind. Thanks in advance! Holly

Well I'm trying to take baby steps. My ultimate goal is to be able to take an inquiry from a form and display all the records that match, along with the total. I would like the user to be able to choose which field and the value of that field to search for. I'm trying to teach myself so I know...

Well it returns the correct answer! (I'm still not sure what the VB code returns because the rcdCount variable doesn't have a value after the code finishes. I couldn't figure out what to do with it to see it besides put a watch on it.) I was trying to use SQL to do the same thing but I...

I don't know what I'm doing yet and maybe I'm going about this the wrong way. I'm trying to come up with a count of records meeting variable criteria. My code is: Sub TestGetInput() DoCmd.OpenForm "InquireWithin", acNormal Dim TrackingDB As Object Dim TrackingFields As Object...

That did it. THANKS!

First: I'm trying to teach myself Access so I don't yet know what I'm doing. I have a table which is a log of telephone calls. (CallLogTable.) One of the fields is CallType. I want the field CallType to be populated from a list of possible call types and I've made a separate table of the...

Thanks Bob. I'm sorry for the ridiculous way I posted that. My real problem is that I want to get a button to do the move to a new record part. The only way I've figured out to get to a new record when on a form is the little teeny arrow at the bottom. Is there a better way?

I am extremely new and trying to teach myself Access. I've created a form called New Call with several fields and added a button that says, "New Record." I thought I could just do a macro to get the form to blank out and accept input when the user hit the button but there's no method on the list...