Search results

hi all, i cant even attempt to write this one, so i would like some help if anyone can write this... heres the idea... 1) i want a FORM based piece of code that closes the form after 5 minutes of inactivity 2) i want to close the database when any pc goes to screen saver please help me...

hi all! please review the attached files for screenshots of my issue. the database i have here has worked forever UNTIL we upgraded to office 2010. that is the only difference and it still works on PC's that do not have office 2010. This is the error I am receiving on this code...

how do i create a totaling query that results in monthly totals? available fields: date category amount

well the append idea sounds doable, can you help me write that?

well currently text 1 with control source A is bound, text 2 is unbound but i would like it to be bound to control source B. the data dehind the form does support a right join but that does not write to the second table. think of this more as a data entry form rather than something to view...

im essentially merging 2 databases together as one and rather than a massive re-desgn project, i just need to do as i stated to effectively link the 2 together as one. i would have to redisgn 3-5 external databases as well as the secondary one to avoid duplication, and even though there will...

hi! so i have a form for data entry and i am trying to reduce the duplication of user actions by having 1 field in my form write the same exact value to another "hidden" field on the form example: text 1 with control source A - is my visible text field where a user will input a value...

im open to ideas, though i think my wife would prefer the simpler 1 box solution like the after update thing.... any ideas how i can structure that method to meet my needs? i want my [amount] field to change to a negative value if my combo box states "withdrawl" also, can you explain more...

ok woot we got that going now! thanks a ton alan! now next question is, how do i make my "amount" field become a negative number based upon the word selected in a seperate combo box

please see attachment of my error, im sorry to burden you with this, but im not all that handy with sql

thanks for the help, but im still stuck :( ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SELECT [tbl_Orig].[UniqueKey], (SELECT Sum([tbl_Orig].[FieldToSum]) AS Total FROM [tbl_Orig] WHERE ((([tbl_Orig].[UniqueKey])<=[tbl_Alias].[UniqueKey])) AS Total FROM [tbl_Orig] AS [tbl_Alias]...

thanks for the suggestions but i guess we are going to have to call me dense on this one.... ive got this going as a calcuated field in a query of my check book transactions table: balance: DSum("amount","checkbook") for reference sake: new field name: dsum("field","table") this is...

so i am trying to make a fancy version of a checkbook transaction register with access. i then realized that i have no idea how to write a calculated field that can add or subtract based on the balance of the previous record. anyone able to help me out here?

you are right again! i needed to reference the field name with each criteria. that did the trick, thank you!

please check out my attachments, i marked up the "a" image with some description of the layout of my DB. i indicated which field is the job status field which contains the field values i am using as criteria for the conditional formatting. please refer the job status field on the report to...

ok i changed that null deal, but my colors are still not correct.

here is an attachment of a screenshot of my formatting, things are turning green that should not be green, yellow and red are not displaying at all. ideas?

ok, we got this working for the most part, but now it would seem that the ordering of the conditional formatting is out of whack. some records are turning colors they should not be turning based off of my criteria in the conditional formatting. what am i missing?

ok ive got the 2nd method working with conditional formatting. how do i call out a blank field with conditional formatting? i was using [job status]="word" but im not sure what word to use for fields that are naturally blank (defaulted empty fields)? i tried "" and null and "null" and...

nor is this: Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer) If [job status] = "job complete" Then Me![GroupHeader1].BackColor = vbBlue Else Me![GroupHeader1].BackColor = vbRed End If End Sub