Search results

Before I read all that - did you try the code I posted?

Here is the code and the attached database. Realize that the destination month field is a Date datatype, so a date must be given (it would have been easier if it was a text datatype and we could just insert the field's name). This meant that we had to force the date to be the 1st of each...

Glad to hear it. Menucommand still works in current versions of Access, but is considered obsolete as Rich said, which is why I the Runcommand. Either should do just fine for what you are trying to accomplish.

Then use VBA. Dim strSQL As String Dim rs As DAO.Recordset Dim db As DAO.Database Set db = CurrentDB Set rs = db.OpenRecordset("Current Table Name",dbReadOnly) rs.MoveLast rs.MoveFirst Do Until rs.EOF strSQL = "INSERT INTO [NewTbl]([PartNum], [Date], [WhateverNumIs]) VALUES...

Spectro, the reason why you're having trouble getting an answer is because you are very unclear about what you want and your explanations go on tangents. I've cleaned up your code (below), but am unsure how you're retrieving anything from tblStandards, other than maxID/minID (unless your form...

Just extending on what doc is saying; replace the slash with a null string: UPDATE [Table Name] Set [Field Name]=Replace([Field Name],"/","")

DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 or Docmd.RunCommand acCmdUndo

IIf ( WeekDay(DateAdd("d", 2, Date)) = 1, DateAdd("d", 3, Date), IIf ( WeekDay(DateAdd("d", 2, Date)) = 7, DateAdd("d", 4, Date), DateAdd("d", 2, Date) )

Easiest way, use 4 new insert queries: Create a new table (PartNum, Date, Whatever that number is) INSERT INTO NewTbl(PartNum, Date, WhateverNumIs) VALUES (SELECT itemno, qntydate1, wheverthatnumberis FROM CurrentTable) INSERT INTO NewTbl(PartNum, Date, WhateverNumIs) VALUES (SELECT itemno...

Used to intern for them in Norfolk. Was looking for a job there, but not really anymore. This is off-topic though, did the new recordset work?

Is this program for Norfolk Southern? Just set the report data to the SQL info. Report.Recordset = "SELECT * FROM zz WHERE TT in (" & strIN & ");"

The thing I like about a web-interface is the ability to use it anywhere, with no extra software installed, only a web browser. There is a future, scalability function of web-pages that applications are more difficult to get around. For instance, what if you wanted to do work from home? If...

It all depends on what you're trying to do - there are many solutions out there.

Yes, yes, that is what I meant. Do not use the 10 then 13 as my previous post stated, 13 -> 10 is the correct order and order does matter. Thanks for correcting me Rural.

You cannot change the order of records in a table. When records are pulled from memory, they are loaded in order of most quickest retrieved; they are not retrieved on a particular order. It just appears that they are normally in order based on how they are loaded into memory and their memory...

You can just use an UPDATE Query. What exactly are you trying to do? If you actually wanted to put an order on the CT record, use the ORDER BY in your SQL and use this: IIF( [Field]="CT", IIF(DMax("[Number Field]","Table") & ""<>"", DMax("[Number Field]","Table") + 1, 1 ), 0 )

You should then use SQL Server for this. Access has a 2GB limit and really has many undocumented issues that should not be used for plantwide operations. What you might want to do is design a webpage in ASP.Net using VB.Net or C# for the front end, that connects to the SQL Server backend. If...

First, please format your SQL as so; notice how easy it is to check for comma and other syntax errors: SELECT Onderneming.EntiteitId ,Onderneming.EntiteitNaam ,Onderneming.Straat ,cstr(Onderneming.Nummer) ,Onderneming.Postcode ,Onderneming.Gemeente ,Onderneming.[RSZ...

Doing a chr(10) & chr(13) is also something you might want to use. It is what is needed in a Report's textbox since vbCR, vbLF, vbCRLF, vbNewline, or any other vb* constant is not recognized.

Correct, except for the port, you can define which port to use.