Search results

Hmmmmmmmm, OK, 1) lets talk about the ID, what do the individual parts meen? ie ABC -What is this bit 0309 -Date YYMM 00x -00x does this meen (0012) or (012) 2) from what i can gather so far you will want to store the date part as a date the autonumber part as an auto...

Let me get this right, do you want to know how to store it or how to show it? am i right in assuming your date format is a follows Month YYYY DDMM If the above assumtions are correct, store the data as a date and use a custom date format to display it. just set the control format to mmmm...

Might i suggest a simple little program called MS Paint, it works wonders

Also, read the paragraph in bold Remember Help is your friend

I would think it went somethink like this if me.recordlocks = 2 then msgbox "Record is locked, you can't change the data" end if

You will have to make a ado/dao record set then row process using DateDiff in VBA

The simplest problems are the hardest to find Good luck M8

I suggest having a look at the .RecordLocks property of the form.

This is beacuse you are using the Write method, Try using the Print method instead. ie Print #1,"Some text to print" this does the same job but without the ""

Now your asking complicated questions......... a compiler basicly takes your code and converts it into 0's and 1's that the computer understands. More advantages of vb 1) it doesnt crash as much, 2) you have much more flexability if what you can do

If he wants to do it let him, its his program. yes you can, you just need to add a where condition to the update query. you normaly base it on the primary key of the row you want updateing. Note: Even if you do calculate in your reports (this is the best way), its probably a good idea (as an...

y not just set the other form to open on a double click then, you can select from the combo without trouble.

Create an update query and run it

IMO the biggest difference between VBA and VB is, VB is a compiled language VBA is not making vb far faster and more stable.

Soz cant help on a book, i would of thought by coding the line it wound not of changed : D to :D

I susspect the problem is one i have come accross many of time useing ; InStr([start, ]string1, string2[, compare]) and Replace(expression, find, replace[, start[, count[, compare]]]) Its simple and easy to fix, although the compare property is optional it isnt, this causes your crash...

Just a thought you might want to spread your msgbox over more than one line, you can do this using : vbcrlf ie msgbox("You are about to export (" & rs.recordcount & " no. of records)." & vbcrlf & "This will update the current data base." & vbcrlf & "Are you sure you wish to continue?"...

Doh! :rolleyes: :eek: How did i miss such a typo :confused: :confused: Ta m8 for spotting it, fixed it now :p

Hmmm, i might get the syntax wrong a bit but here goes sub ExportCmd_click() dim rs as new adodb.recordset dim sql as string sql = "Select the records for export" 'you need to change this sql statement to retrive the files for exporting rs.open...

Although i cant understand your post i have stream lined your code for you, it might help. But without knowing exactly what your problem is i cant help any more. :cool:ShadeZ:cool: Dim strSql As String dim rst as new adodb.recordset Private Sub cmdAddAddress_Click() if MsgBox("Do You...