Search results

Glad to help I never realized you needed for T-SQL.

Try this between cint(Start_Year & right("0" & Start_Weekno,2)) and cint(End_Year & right("0" & End_Weekno,2))I joined year and week and converted to integer. In your example it would be between numbers 201338 and 201414 Right() function is meant to convert single digit week into double digit...

Thanks. Actually that was very first thread I tried before posting here, but it works only when control can get and has focus.

AOB pr2-eugin Thank you for reply. Indeed what you propose is correct and that was my intended next step. What I was hoping for is that instead of changing 100 labels, to make one and copy paste the same code something like: Private Sub Label1_MouseMove(Button As Integer, Shift As Integer, X...

Hello I have a form with about 100 labels and would like something to happen when I mouseover. So I have a following code: Private Sub Label1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Label1.BackColor = vbBlue End Sub Private Sub Label2_MouseMove(Button As...

Thanks for reply namliam Could you elaborate what kind of issues will appear. Just to clarify, I am not deleting actual tables with data in back-end. I am deleting only links in front-end.

Hello This is not a question on how to, but more about your expert opinion. As you all know tables are linked using absolute path and if you change back/front-end location one needs to re-link the table manually. I have been searching around on how to do it automatically when both files are in...

Thanks it worked

Hello I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code: Dim PctBZ As Double Dim PctBA As Double Dim PctKI As Double Dim PctMA As Double PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI +...

Hi You need to make Group By query. This is the SQL of the query. SELECT Pull_packed.Date , Pull_packed.[Transaction Type] , Pull_packed.Name , Count(Pull_packed.TSPN) AS CountofTSPN , Sum(CDate([Pull_packed].[Time])) AS [Total Elasped time] FROM Pull_packed GROUP BY Pull_packed.Date...

when you say each table has 100 fields, do all 100 contain costs? do you have to substract 100 fields from another 100 fields from another table, is that what you mean?

So it is not 5 different records, but 1 record with 5 fields, right? If so, it is possible, but let me ask you, why do you need the same thing to appear 5 times? Just save it once and use it as many times as you want on forms, queries or reports.

Hi, First of all attached error message contains different IIF expression than in the post; secondly according to message your query is using Group By and the result of your expression is not aggregated (apparently). Could you post complete SQL statement.

I really don't know. You could also send it to me in PM I guess

Would it be possible for you to attach mdb?

Hi, Not 100% sure what you mean. You want "...to fill out 5 records in one row...", but one r0w is one record, so how could you fill 5. Could you please rephrase.

Why don't you put <DoCmd.GoToRecord acDataForm, "frmPurchaseOrder", acNewRec> in On Open event of the form which needs to jump to new record (which in this case is the subform "frmPurchaseOrder" I beleive)?

Oh yea, and set Data entryto No

I edited above post, see the code

So in other words when you open the form you want to automatically go to the new record, but still have option to go to the previous records, is that correct? If yes, in the On Open event of the form add the following code: DoCmd.GoToRecord acDataForm, "YourFormNameHere", acNewRec