Search results

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...

I have a query that get its parameters from a form, and everything except one thing is working great, thanks to the many suggestions from this forum. However, I have one last problem that is giving me a headache. I have a combo box that has 7 options, one for each "stage" a record is in. In...

thanks! works great now.

Hello, I have the following sql statement IIF (CCOdate = null, DateDiff('d',CDApprovalDate, actualdef), DateDiff('d',CCOdate, actualdef)) AS finalchangeage " The query runs and performs correctly for the false statement, but it doesn't calculate anything for the true part. Any ideas as why...

They are valid and the query runs fine with the dates added in, I do have another question about that but I think that will be a thread for another day. Most likely, I will be the only person using this database. One of my managers might run reports but I think she will just ask me for the...

Ok, so I added a third criteria, just like the previous two, and now my query displays no results. Private Sub cmdok_Click() Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strCriteria1 As String Dim strCriteria2 As String Dim strSQL As...