Search results

In my opinion you can change the border style to none and set modal to yes so it's harder to normal user to enter your program. On my login I also add a code on load to minimize access windows so even the right click not work and can close the form. and trigger every 0.5 sec so my noob users and...

I found the error... I had in a code and if nz( ...) =false then exit sub that was the problem because on new record it is empty... sorry and thanks

Hi I need to trigger a code when I navigate on my subform to a new record on current work great for all my record but when I enter in now record in a subform that record is not yet created and I like this but I need a design code to trigger any suggestion?

I had same problem for filter date because filter accept only #dd/mm/yyyy# but Cdate in my system return dd.mm.yyyy. and filter doesen't work so I added a calculated field in query and return month as integer and filter that field and not date...

try this >=#Cstr([date])# and <=#Cstr([date]) because in query between ## must be a date as string

Ok, sorry for my bad English but English is my second foreign language and I try my best... I have to make a database with 3000 patient, 5 workers to arrange every day appointment. Around 250 patient/month are active, and I need to every one determinate witch day of month are active and this...

Hello. I have 31 checkbox to determinate which day of month to be in calendar with iif([01]=-1;cdate("01/" & [month] & "/2015");cdate("01/01/2001") in the query to get date field to compare to paid date for that customer... now for list unpaid date I have all the customer who has date after...

I make it hard way :) Cint( right 2 of left 5) and I got a number of the month then filter Cint(month(date)) or Cint(text)

Not working... I try to make a query with new field where replace . to / and now the filter is working but not correctly... if I filter date >= then 01/07/2015 it show the date where the day is higher then 07 and all month, and if I replace dd/mm to mm/dd it's not working at all... any idea...

Glad to help you, but it's strange, with windowstyle 2 it's minimized in my code :D

thanks, I got I step forward. I live in Croatia and they got the great idea to define date as dd.mm.yyyy. with . after yyyy and if I do CDate for 20/02/2015 I got 20.02.2015. but in code with / I got no more error filter on but the date field not filtered... Now I can continue working... thanks

Hi I had the opposite problem, I need to minimize cmd so I did Dim wsh As Object Dim waitOnReturn As Boolean: waitOnReturn = True Dim windowStyle As Integer: windowStyle = 2 Set wsh = VBA.CreateObject("WScript.Shell") wsh.Run "MY cmd file", windowStyle, waitOnReturn not suse if work for jpg, try...

I'm feeling noob to ask a question about filtering because I did a lot of time but this time I can't find a way the easy code Dim StrDate As String If Nz(Me.Text42.Value) = False Then StrDate = "01." & Month(Date) & "." & Year(Date) Else: StrDate = "01." & Me.Text42.Value & "." & Year(Date) End...

Hello to everyone. English is my second foreign language but I need for programming so I'll try my best. I'm a owner of a 25-worker business and responsible for hardware and software part of working. We had for too long a dos program for schedule more than 200 patient/month to 5 nurse... that...