Search results

Access 2010 specifications

It sounds like you want something like the Package Solution Wizard Package Solution Wizard - Page 1 of 4 Package Solution Wizard - Page 2 of 4 Package Solution Wizard - Page 3 of 4 Package Solution Wizard - Page 4 of 4 Microsoft Access 2010 Package Solution Wizard is not available

When I processed files I had two folder, In & Out. I would put any new files into the In folder, process the files and automatically move them to the Out folder. If there is a way of telling whether an import has been successful or not it should be possible to add a Failed folder as well if...

Right. I have attached a demo of the following. I started by writing the function tmpGroupName() that would allow me to pass a value into a query. Public Function tmpGroupName(Optional ByVal tgnGroupName As Variant = "") Static sVarGroupName As Variant If Len(tgnGroupName & vbNullString)...

I'm afraid I'm going to naughty here. There is a new way of doing it with the fileSystemObject but I've not had the opportunity to get to know it yet, so I'm going to stick with a method I know. Public Function importFiles(byVal ifDirectory as String) Dim strFile as String, rstImports as...

Or if you are using a bit of VBA code. Dim lngCount as Long lngCount = nz(DCount("*", "yourTableName","yourFieldName = " & yourValueValue), 0) Only if no existing records are found will lngCount return 0.

This could get confusing. :confused: One minute I'm posting about Microsoft Access VBA the next about biblical philosophy. :) Perhaps I could condense it down to a bit of VBA. Debug.Print Not IsMissing(God) True or False. ;)

So that's .. Me.field1 = Left(Me.field1, InStrRev(Me.field1, ",") -1) You may need to account for null fields. If Len(Me.Field1 & vbNullString) > 0 Then Me.field1 = Left(Me.field1, InStrRev(Me.field1, ",") -1)

The original quotation. 0.0044% is 200,000 (the age of Man) divided by 4,500,000,000 (the age of the Earth) as a percentage. So the question was actually .. So has Man begun to unravel the secrets of how parts of the universe work or has Man just sat back and said "Because that's how God...

You were, but the code in the original example wasn't, it was looking for the "." Left([Filename],InStrRev([Filename],".")-1) This code is looking to remove the file extension "file.txt" Which is why I mentioned about changing it to look for the "," instead...

I've not used it but there is an InstrRev() function which works like Instr() but right to left rather than left to right. There is an example on that page for removing extensions from filenames. Left([Filename],InStrRev([Filename],".")-1) Perhaps it would work if you adapted the expression...

Are the scrolls in English, or a language who's meaning has remained unaltered over the centuries? (I'm guessing the answer is probably no). I would also surmise that "A being that has been around for 0.0044% of Earth's existence..." is more likely to be Man than God. Even if there were...

Depending on your version of Access you may find that Replication has been discontinued. When I did this sort of thing, back in Access 97 & 2003, I added some special fields to all of my tables. ID * - obviously the unique identifier of the record. deleted - a Yes/No field to show whether a...

All based on stories from a book by an unknown author which has been altered time and time again.

The Bible is probably (at best, and IMHO) a translation, of a translation, of a translation, of a man's interpretation of the words of a mythical being who's existence has been neither proved nor disproved. To see the Bible as the word of God would definitely require faith.

Create yourself a Public Function thus... Public Function formatOfField(ByVal fofField As Variant) On Error Resume Next formatOfField = "<none>" formatOfField = fofField.Properties("Format") End Function Pass it a field to work with and it will pass back either "<none>", if no format is...

Once you have established who, and what, God is. You then ask yourself ... Who created God?

"It is the work of God" is an easier phrase to admit to than "I don't know". But once you start to understand things for yourself then God starts to be replaced with facts. The Earth has been proven to have been around for approximately 4,500,000,000 years. Evidence has been found to show...

No. No. I would imagine that none of your criteria for selection were bound to any fields in any table. :confused: If they were you would be changing them every time someone changed the criteria. You can use fields as "unbound" just by not setting a control source for them. They will still...

Ah, that's possibly more difficult as a checkbox can either be True (checked) or False (unchecked), unless its in an initial NULL state. Off the top of my head I would say that you could do something like this. Replace the checkbox with a combo box set up as follows:- Column Count: 2 Row...