Recent content by superfly5203

I had that in before but took it out, so I put it back in and now I think my string is returning a null value. I'm not getting any results, and if I remove that part of the WHERE statement, everything works (it does show all records instead of matching records of course).

That helped a lot, I found it didn't like the space in my new field after the AS. So i changed AS Proposal Delta to AS Proposal_Delta and it got past that error. Now it will run the query correctly, but there are two pop ups asking for the 'contractlist'. If I type in a contract name twice, it...

I tried to put the code in the command button which compiles the SQL statement, but now i get a run time error 3141 The SELECT statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. Earlier it was said you can't use the IN with VBA...

I think I found my problem. I feel pretty dumb really. I total forgot that my form builds an SQL statement every time i hit the command button so it rewrites the query every time. I went back to check everything one last time and I saw that, and like I said, felt pretty dumb. thanks for helping!

I did the compact and repair, and nothing changed. Is there an easy way to remove all the sensitive info from a database without messing something up? There are lots of fields I would need to delete or make zero before I could upload.

All of my queries are select. Here is the SQL from the query that does work SELECT tblSSCN.SSCN_Number, tblSSCN.SSCNTitle, tblDates.actual_proposal, tblContracts.ContractName, Abs([tblDollars]![prop_price]) AS [Proposed Price], [actual_proposal]-IIf([tblMod.TypeLetter] In...

Thanks that worked great! I thought it would be something simple like that.

I used this code and it worked great. However, I'm having a rather infuriating problem with it now. I was adding this to an existing query and the query won't save this formula. Well, it does save, but when I open the query again it is no longer anywhere in the query. I've made new queries and...

The Row Source is: SELECT [tblCO].[COID], [tblCO].[CO_first_name] & " " & [tblCO].[CO_last_name] FROM tblCO; And the Control Source which points to my summary table, if it matters is : Assigned_CO_ID

yes it should.

Sorry I went back and read what I wrote and didn't even understand it, really sorry about that. I have a a table for people's names, and there is a field for first name and a field for last name. I have a form, that is used to input data into several different forms. On this form, I have a...

Hello, I'm working on a access 2010 database, and I have one form that just about all the information for the database is entered into. I have a couple combo boxes for name of people, and one for Contract name. When I made the boxes, I linked the ones for names to the first_name field, in...

OK, I'll try again. The database tracks small projects, each project is completed by one of three different companies. The timeline for each project is as follows; the project is started, a proposal is delivered, the proposal is evaluated, documents are drafted, the work is negotiated with...

Do I need to provide some additional info? or is what i'm trying to do not possible?

Sorry about that. My database tracks information relating to contract changes (a change is essentially a small project). The DB has 5 tables, one for basic info, one for dates (this is the one my question relates too), one for dollars, one for types (there are 12 different "types" or categories...