Search results

bob; Hi and thank:) and a qustion: how can i used character "*" ? (beacuse it say yes for any record that is 1)

I have searched the forum for count of character but I can't count character "*" in a text box ("d" or "s") on my report footer Can anyone tell me of a simple or see my file? All suggestions appreciated

In one Report must print from text into Dtail and Page (or Reprot)Footer by click on Button-1 and the next print must from Detail only by click on Button-2 i used code below on button-1 but... Dim stDocName As String Dim stvi As String stDocName = "Report1" stvi =...

Hi all, in the frmA has text box "AutRow" that add autonumber for every row. Private Sub Form_BeforeInsert(Cancel As Integer) Dim tmp As Variant tmp = DMax("AutRow", "table1", "") If IsNull(tmp) Then tmp = 1 Else tmp = tmp + 1 End If Me!AutRow = tmp End Sub My problem is below: If...

Packup The Table only hi Oldsoftboss; thanks for your db I want backup from Tables only, beacuse my main data is in a table. I used a code in below on click a button of form and then backup a table call "test" in my the db without unload the db. Can I want help me to create select the path...

hi Groundrush; many thanks. I do this, but i want hide buttons by code. I get code for hide min max buttons of windows.

Convert SQL string to VBA code hi I need create Union query by VBA code. I have an SQL Statement. SELECT id,name,school from tblStudent UNION select id,name,school FROM tblTeacher; but this below code can not convert SQL string to VBA Dim strSQLStart As String Dim strSQLFrom As String...

hi I want hide Min Max buttons on main Form. can you see my file and help me? thank

please guidence hi Scottyk537 thans for this code. can i let you send a sampel db with used this code. i wante hide min max bottuon on my form dy code but i can not used code in db. thank

can anyone tell me more about "Setting the PrtDevNames and PrtDevMode properties"? thank

hi is there any way to automatical change a defult printer for a report space? i read in Access help that is a way "Setting the PrtDevNames and PrtDevMode properties", but i can not this. can someone help me. thanks

hi. I want type once day in text box call "Date" on the main Form as it allow this day for many record.for exmaple: rec date code S_N 1 2007/02/07 PE15 EU14 2 2007/02/07 PNoh US15 please tell me waht i do?