I wouldn't waste my time replying to this character. If you notice his status, it is marked as "Banned". DanyWeb has obviously gotten plenty of complaints about him, but for some reason continue to...

So, what's your question?

Hoppy :icon_question:

Your age is no excuse for your laziness!

Hoppy :yawn:

Your problem is on the MsgBox. Try the following:


Call MsgBox("Sorry, there is no such record found in the database with Employee ID :" & _
Trim(txtsearch.Text) & "." & vbCrLf & "Please try...

You can do this using Call DoCmd.TransferSpreadsheet(...).

You can read about the parameters of this call in the Microsoft Access Help file under TransferSpreadsheet. You can use...

How are you connecting to the database? If you are using ODBC, you need to create a like ODBC element on the new computer.

Hoppy

The best way to do this is with a macro. Macros in Excel are written in Visual Basic. I don't think you can create such a macro by recording, but you could try. If you don't know Visual Basic, and...

Sorry to have to break the news to you. The code you posted is totally unusable. It has to be rewritten by someone who knows how to program. Even if you get the code to work perfectly, the code is ...

The code you posted, apart from having a number of syntax errors does not really do what I understand you to want done (according to your first post). It reads a CSV file into a record set and sorts...

In whatever code you develop to solve this problem, consider what you would do if the user types in a formula that contains multiple functions (e.g. 3 + 4 - 2).

Hoppy

As I understand it, the philosophy behind this and virtually all other forums I have either joined or observed is that the participants are there to help people over the stumbling blocks in their...

You should mark the thread as "Solved".

Hoppy

What kind of text file are you talking about? A CSV file?

Hoppy

You're wrong. I tried the following code on my machine and it worked!!


Sub main()
Call MsgBox("myfunc = " & CStr(myfunc))
End Sub

Function myfunc() As Integer
myfunc = 1
End...

To understand this, you need to go back to basics. "OR" is a bitwise operation. The binary for 2 is X10, 3 is X11. ORing the two gives X11 which is 3.

Hoppy

I'm sorry, but I think it's against the DaniWeb rules to do that. If you just click on my name in this or any other thread in which I have participated, you will get a dropdown box. Click on "Send a...

Yes,

1. Create a ListBox on your form.
2. Open the Properties Box and click on the "Data" tab.
3. For the "Row Source Type", specify "Table/Query".
4. For the "Row Source" enter the name of...

I wasn't suggesting that. I was only asking if macy2323 wanted the field names in the table to appear as the first row of the spreadsheet.

As it turns out, after having looked the documentation,...

Coming up with a good design doesn't take as much time as you imagine. And it's the most important skill you can have as a programmer. And it's much more important than "coming up with something" on...

You can get any form from the AllForms Colllection. Here's a little code shippet I lifted from MSDN:


Sub AllForms()
Dim obj As AccessObject, dbs As Object
Set dbs =...

In Excel, the rows are designated by numbers (1, 2, 3, etc.) and the columns are designated by letters("A", "B", "C", etc.).

Anyhow, here's what you need:

Call DoCmd.TransferSpreadsheet( _...

I looked at your screen shot and I looked at your code. I also looked at the answer you gave to Yello's question.

From my look at the screen shot, it seems to me that you have not really thought...

I'm not sure what you mean by "calendar form". Since you haven't got any responses, maybe nobody else does either. I can tell you how to export a table to a spreadsheet so that the first row contains...

You are focusing on the user interface. Have you given any thought to the database? You need a table that describes each time period each professor is teaching a subject and what section that class...

Try this:

Dim str as String

str = TypeName(inputVariable)

Hoppy

Your answer indicates that you are talking about an intranet. This means that you can do certain things that you cannot generally do with an Internet application.

Are you sure that you really...

If you want to be able to type in this information, you will need to create a form. The form should contain information to orient the person entering the information as well as fields into which the...

Dim wrkJet As Workspace
Dim db As Database
Dim rs As Recordset
Set wrkJet = CreateWorkspace("", "Admin", "", dbUseJet)
Set rs = db.OpenRecordset("CREATE TABLE tbl (fld1...

Your question is much too vague. It seems that you have a lot of assumptions built into your question. For example, you are assuming the server in question even has Access. This means that it is a...

I'm still not quite sure I understand exactly what you are asking for, but I'm going to take a stab at it. Firstly, you need to realize that mysql or any other SQL does not operate on data files on...

Thinking about your original question, it really seem like what you want to do is to have two tables that represent your invoices. One table (InvoiceHeader) that contains one row for each Invoice...

You can find a tutorial on ADO (ActiveX Data Objects) on www.w3schools.com.

Hey, that's pretty nifty!

Hoppy

Firstly, I don't think that yello's solution will work unless both files have exactly one row.

If you initially load both files into a single table, say by loading one file and then appending the...

Hi,

I will be happy to do your project for you. If you will e-mail a document that describes what you want done, I will quote you a price for the job.

My e-mail is ersatzname@yahoo.com.
...

Create a table called Inventory that contains all of your products with a field called "ProdId". Create a table called DesiredProds that contains the product id's you want to select.

Use the...

Initialize highval and secondhighval to a value that is lower than any possible value in the data.
Then, iterate through the array with the following logic:

If curval > highval Then
...

Your description is kind of vague. So, I'm going to make a couple of assumptions. Firstly, the two data files are similar in structure. I assume that the first data file has a key field that you can...

It looks like you confused columns and rows in your description in the first paragraph. If this is the case, I can do what you ask, but it will require some programming.

I will charge a fee of...

Where do you want to get the name of the database from? The choices are to hard code it, (not your favorite obviously), to pass it as a parameter to the application via the command line (not my...