Search results

It seems like its doing the OnCurrent events and THEN displaying the Switchboard form. This is when it first starts up. Is that correct?

No, POPUP is set to NO

Hi, I have a form that opens up when a user logs in to the database showing him any unfinshed transactions he needs to complete. I have set it to open in the OnCurrent event of the Switchboard, and also do a SetFocus command at the end of the OnCurrent event (and I thought that was the last...

Still going nowhere fast... I did manage to make 2 queries to give the the total number per month, but not every month is listed and I cant seem to combine them.

I have a table called Projects Each project has a Target Close Date And some have an Actual Close Date I want to create a chart that has months on the vertical axis (July to June) and number of projects on the Horizontal axis Then I want 2 lines on the chart showing how many projects were...

ok well heres the table, the whole db is a bit big

It wont let me close the table, just says " Unknown function 'CurrentUser' in validation expression or default value on 'Quotes.Entered ECL' " Can I alter the table with SQL (I tried to but cant find the correct syntax) Or make a new function that will be known that just puts the value in...

Yea I tried it with and without the equals sign, always with the parentheses.

Yes I am using Access security and it worked beautifully in my form thank you! :) I dont suppose I can use that as a default vlaue in a table can I? When I tried it it said "Unknown Function" Could I write a function the default value can call that will return that value?

I have a database where everyone has to log in. When they fill out a particular form, I want to automatically record thier username in one of the fields. Is that possible?

instead of the "Me" line I now have: SQL = "UPDATE Quotes SET SearchMemo = '" & strSearchMemo & "'WHERE QuoteDBID = " & strMemoID(i) & "" DoCmd.RunSQL (SQL) strSearchMemo = "" So Im just using SQL to put the new value into the table. I found that I had to set the string to nothing before...

Cool thanks. I had a bit of trouble getting that version to work on my database but it helped me find another one that worked perfectly. Here is my final code in case anyone is interested: (This is in a form that contains a subform of data that needs to be concatenated and put into a field on...

I have a subform that has a [Description] and [Drawing Number] column. I want to get a field in the main form to contain a long string of all the [Description]s and [Drawing Number]s in the entire subform combined. How can I do that? For example it would put the following in a single memo...

I want to make a chart that shows the number of PLANNED CLOSE DATES and the number of ACTUAL CLOSE DATES for each month of the current financial year. How do I make the Query to base this chart on? Its been driving me crazy! :confused:

yea i could have 52 boxes, 1 for each week of the year. any that are in the affected timescale will turn green. thanks for your help!

Would it help if i could get the width and left values calculated in a query and base the continous form on that query?

thats a shame, cos i need it on a continous form... is there another way? can i use a chart? can i somehow get vba to cycle thru all the rows and set each length value?

I have a table of projects with a start and end date for each. I want to add a field to my form that shows a graphical representation of when in the year that each project is scheduled for. It would be like a bar with a section coloured in. For example: project 1 is scheduled for Jan 1st -...

Yea good point. I am now using a continuous form. I have my button and can now also hide a couple of fields I don't need to see. Thanks :)

Yea I thought that might be the way. Guess I could do that. No way of doing it in a datasheet then?