Search results

I have had a lot of trouble with the replace function. every now and again it decides to stop working, rebooting the computer fixed this problem most of the time. I finaly tracked down the cause of this problem to using the defaut search option with the replace function. try something like...

you can also use currentproject.path

Ok back to basic basics:D The error message your getting meens that either, OrigSelTop or SR.SelTop doesnt exist yet. (it will be SR) to find out which is a fault run the code when the code stops hover your mouse over the variables, or print them one at a time into the intemidiate window...

I think what ur looking for is the .caption property of the report. I beleve this property is used to create the filename. give it a try :cool:ShadeZ:cool:

This sort of thing is above most access developers, but i can c where your going wrong in order to use a class u have to create an instance of that class (Using the NEW keyword) this can be done in 2 ways. 1, when the class var is declared, ie Private SR As NEW clsSetRow 2, or any where in...

I have had a similar problem to this Query's cant take the value from the activex calendar i have 2 solutions 1) this might not work i didnt try this, change the reference to the atx_calendar to point at the calendar.value property not the calendar 2) this works, place a textbox with the...

The answer is yes! VBA can do the job. Its a bit tricky so hope you can understand, Open a ado or dao recordset with all the data you need. With this data you can then create a text delimitated file in your format (i used the following format) {tablename}filed1,field2,field3,fieldN...

Im having a little trouble with the auto number, I have a table with the auto as the primary key, the problem is that the autonumber for new records is less than the max value of the autonumber field. eg max value in key field (2254) Value auto uses for a new record(2233) I didnt think this...

That seems over complicated to me try if me.recordset.eof then cmdlastrec.Enabled = False cmdnextrec.Enabled = False else cmdlastrec.Enabled = true cmdnextrec.Enabled = true end if if me.recordset.Bof then cmdprevrec.Enabled = False cmdfirstrec.Enabled = False else cmdprevrec.Enabled...

Of corse its possible all you have to do is add a TextBox or something to ur main form. in the control scorce run a query to chk the notes eg) iif(nz(dlookup("notes","NoteTable","notetable.callid = " & Callid) ,"") <> "","!","") this should do the job :cool:ShadeZ:cool:

You can use the where Property on the report. if u use docmd.openacreport "MyReport",acpreview,,"Mydate >=#" & mystartDate & "# and Mydate <= #" & MyEnddate & "#" to open ur report. the other way is to get ur query to take the start and end date from your form. :cool:ShadeZ:cool:

Look up INT and FIX in VBA Help :cool:ShadeZ:cool:

Your answer is yes and no No, there is no real way to pass data to excel using the method u discribed. this method only opens up a copy of excel with the file selected. Yes. In order to edit excel spredsheet from within access u need to open excel using VBA and MSOffice Libraries. Its not that...

try somthing like this =iif(nz(SomeField,0)=0,0,AField/SomeField) This will check if somefield is 0 or empty if so return a 0 else do the calculation. ie IIf((Nz([WtInLg])/Nz([No_Lg_Containers])*nz([LgfrWharf])=0,0, (Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf])))) Would be...

This Is very one sided does noone like Spaces, :cool:ShadeZ:cool:

Soz U should of said u were a vb nOOb ill make it simple for you Sub CopyFile(FileNameAndPath As String, FileNameAndDestination As String) Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject") FSO.CopyFile FileNameAndPath, FileNameAndDestination, True End Sub...

Ok quick poll for you Access Gurus DO!!! you use [S P A C E S]!!!!! in ur field names I personnaly dont use them they become anoying when doing SQL, Whats ur opinion????? :cool:ShadeZ:cool:

ok, u have kicked ur self a bit in the foot on this one but u might be able to sort ur self out. First. Assuming "First Name" is a field name Y oh Y oh Y do people put spaces in field names, they are just an unnessasry nussance,:mad: :( :rolleyes: ok rant over try this or a vairiation on...

You dont have to use DAO for sql u can use ADO (My Favorite) :D to execute Sql use Currentproject.connection.execute sql[,Rows] ie, currentproject.connection.execute "delete * from MyTable" select queries can be done like this Set Rs = new adodb.recordset rs.open sql =...

I have had Dcount error on me, without any error in the query the query ran fine from the query builder, but from dcount itwouldnt work. (Somthing to do with date values i was taking from another form):confused: But like i said earlier if it works and ur happy no problem. :cool:ShadeZ:cool: