Search results

Read my last post i want to change the Between , And to >= , <

DoCmd.OpenForm "customers", , , "[customers_date_visit] Between #" & Format(StartDate, "mm / dd / yyyy") & "#" And #" & Format(EndDate , "mm / dd / yyyy") & "#" i read the link and i made the code above which works great.:) But it shows the first day of the next month:eek: so i decide to...

error code '13 code: Private Sub Qtr_4_DblClick(Cancel As Integer) Dim YearTake As String Dim StartDate As String Dim EndDate As String YearTake = Me.Year StartDate= "1/4/" & YearTake EndDate = "1/5/" & YearTake DoCmd.OpenForm "customers", , , "[customers_date_visit] >= #" & Format(StartDate...

i tried the following code: Private Sub Qtr_3_DblClick(Cancel As Integer) Dim YearTake As String Dim StartDate As String Dim EndDate As String YearTake = Me.Year StartDate = "1/3/" & Year EndDate = "1/3/" & Year DoCmd.OpenForm "frmCustomers", , , "[customers_date_visit] Between #" &...

thxs for the reply one question ? all my db uses dd/mm/yyyy format. is it going to harm other forms? or is it just for this problem.

i tested it but ... i post a sample db

you are correct and very good answer so simple... thxs a lot Krava.

i have an imageframe and 4 buttons. 1)ZoomIn = works fine 2)ZoomOut = works fine 3)Best fit = i tried DoCmd.SizeMode = acOLESizeZoom but nothing 4)Original size of the image = it is the same as above thxs

hi i have a continious form with the fields year || Qtr 1 || Qtr 2 || Qtr3 | etc.. || Qtr12 ---------------------------------------------------------- 2000 4 5 2 6 2001 3 3 6 2 2002 6 4 3...

hi i have a continious form with a combobox and the data has the format customer John customer Peter customer Mary customer Nick i want to hide the word "customer " after i make my choice i tried something in the after update me.cmbbox = mid(me.cmbbox, 8) but it delete my choice any help!!!

Happy New Year i have a form with a web browser control and 3 buttons. cmdBack = move back code: me.cmdBack.GoBack cmdTop = go at the top of the page code: ??? cmdSearch = search inside the page, if you press ctr+F a search window is pop-up. i want to press the button instead ctr+F. code...

have a look at the sample db i want to print each customer and below to put the tblsomething(for this customer), then the tblgeneral(for this customer)which contains 3 tables(tblpay,tblorders,tbldetails). i want to print want i see. the report will look like this: 1 John Mile NY...

hi please help . i don't know how to do it. i have db and i want to make a printable version have i look at a sample db below which is the same the one i use. i want to print order by customers(Customers)ID, something, general. the general tab as you will see has 3 subforms. thxs

hi i have a form with 12 checkbox and 1 combobox i use the following code Option Compare Database Private Sub Form_Current() If Me.Image1 = -1 Then Me.Parent.Image1.Visible = True Me.Image1_text.FontBold = True Else Me.Parent.Image1.Visible = False...

sorry my mistake the table BackUp is holding the name of a file. the code delete the last 5 backupfile BackUp BackUpID BackUpFileName i want to get that filename as a string so i can run kill statement strSQL = "DELETE * FROM BackUp " _ & "WHERE BackUpID IN(" _ & "SELECT MIN(BackUpID) FROM...

thxs for the help i test it and works fine but it doesn't delete the file ??? Where to insert kill statement??

Problem code: Option Compare Database Option Explicit Function Backup() Dim fso As FileSystemObject Dim sSourcePath As String Dim sSourceFile As String Dim sBackUpPath As String Dim sBackUpFile As String Dim strSQL As String sSourcePath = Application.CurrentProject.Path sSourceFile =...

thxs for the reply i have a table with tblImages ImagesID CustomersID ImagesPath as you can see , i store the path/name of the file. Today , i show something else. if i change the registry = Yes and function disable , the db is crashing when i move to next record fast(the image dialog is...

thx for the reply the format is .jpg and the size is between max. 250 - min 100 KB the mouse flash like twice . it looks like when the image is loading, but two times. the problem is that it slow down my db . When i moved to the next record and move on. I have a main form with tabs on it ...

The reason is simple: If i have a db and want to install to a customer to test it, i can to it very simple. i will not have to put expire or password protection. it will be delete when the customer close the pc.(it will close some how.) AND it will be full not demo. If i want to hide as i said...