Search results

I have a database where people are entering data into in constantly. Now I was told that someone else needs to go into the database and check integrity of data entered. There are a few buttons that I don’t want a “data verifiers” to click on, but “data entry folks” should be able to. Is there...

Thank you, thank you, thank you! That worked great!

Yes, and I did that, but that code closes form2 as soon as it comes up leaving form1 open. Any ideas? Thank you!

OK, could you please be more specific as to where to put that event? Are you saying I should insert docmd.Close for Form2 Open event? I tried several combinations of everything and I just can't seem to figure it out. Thanks!

I can't seem to figure out how to close current form. I have form1 and I open form 2 from form1. I can't figure out how to close form1 when form2 opens. Any help would be greatly appreciated.

I recently moved my Access tables to a SQL server. I have been at this for a while now and can't seem to figure it out. On one of my forms I have a pretty large If statement that deals with DCount: If DCount("ProjectStaffID", "qryAvailableDatesCheck", "(((Forms!frmProjectStaff!Start1 < Start1 Or...

Thanks. I will look into this.

Is there a way to dynamically allocate a certain range of days if I know a start day? I have a form where I have a date called startofproject and I want to allocate all work week days from that start date + 90 days. I’m assuming it should be some sort of make table query that will delete all...

Thank you for all your input. I finally found a hidden setting that was (Black Inc Only = True)... Man, that drove me nuts! So I got it now. Thank you again for all your help.

Everything else (word docs and excel docs) print just fine in color. Any other ideas what could be wrong?

Thanks. I will try.

I'm having a problem with printing my report on a color printer in color. It still comes out in Black and White. I checked all the settings and I couldn't find anything that says print in black and white only. Any ideas how I can fix it? Thanks.

Thanks! That worked great. :p

I have 2 cascading combo boxes on Form1. After I select one things out of dropdown0 and then select another thing out of dropdown2, I click on a button that opens another form - Form2- depending on values selected from both of those comobo boxes. That works good. What happens is when I come back...

I used one of the database from this forum to keep track of changes(its attached). I'm wondering if there is a way at all to display on a different form, only changes that happened within the last two weeks. Is there a way to somehow code for the changed data to fall within these 2 weeks? Thanks.

I tried searching and the only thing I found was something that keeps track of changes in a Memo or a Text Box. What I wanted is an actual table to keep track of changes. Also, I used the .oldvalue to set a default "No Previous Note".

I have a form with some Note fields on it. I needed to track changes every time any of the note fields changed. I got that part to work and I put it in the Before_Update even as I'm using Note1.Oldvalue as well as Note1.Value for my changes. The problem that I'm having with this code is that...

I have a DLookup() function on one of my reports: =DLookUp("[TaskStartDt]","tblDatesInfrastructureAndTools","[TaskID] = 52 And [ProjectID]=[Project_ID]") I created a new text field and placed this function in it – this works very well. After that I realized that I want to sort on that...

Thanks...this helped!

I have a DLookup Statement for one of my fields: =DLookUp("[TaskStartDt]","tblDatesonlyPM","[TaskID] = 16") in this tblDateonlyPM there is also a FK to my Project table - ProjectID. What I want is to be able to add to this DLookup statement something that will make sure that ProjectID from...