Search results

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

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

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

I'll start off by saying, I have searched this form and all over google and I have seen tons of these examples, but I can't get any of them to work. I saw one in this thread from a few days ago and a couple months ago, but no matter how much I alter the code I don't get the correct outcome...

I have the following statement in a calculated field which calculates the number of days late a proposal is: IIf([Contract]="A" And [Change Type]=2 Or [Change Type]=4 Or [Change Type]=9 Or [Change Type]=11,([actualproposal]-[CCO Date])-90,([actualproposal]-[CDapprovaldate])-90) This code...

I made a database and I guess I was getting a head of myself and when I started to design a query, some flaws became apparent. I'll give some background onto what my database does. My problem sounds a lot like a poster from yesterday who wanted to know why having one huge table is bad. Right...

I'll try my best to explain what I'm trying to do, I hope it makes sense. My database keeps track of 3 different contacts, and each of these contracts can have 5 different modification types. I have a form, "change entry form" in which all of my data flows into on table, "table 1". The...

Hello, I'm making a new database and I have some fields that I'm hiding when a checkbox isn't selected. I have about 20 or so fields that I want to make a group so I don't have to type them all in, along with the labels for each of them. Is that possible? Also I have noticed that in my form...

Hi, I've been using the forum for a while doing research for an access project and it has been very useful! The further along I get in my project the more questions I have, so I thought I should make an account so I can post. I have some basic programming experience from high school, 11...