Search results

So what's the difference between: strVar = Me.cboOffice.Value and set strVar = Me.cboOffice.Value Because I'm getting a compile error: "ByRef argument by type mismatch". This happens when I send the value to a function.

Hi, I want to write a piece of code. Instead of writing "Me.cboOffice.Value" to refer to the textbox, can I assign a variable to it? I tried to assign it to a string-variable, but It gave me an error. Thanks.

Hi, I can't "point" a text box to a field of a query. How do we do that? Right now, this is what I do. I right-click on the text field. Go to properties. Go in the Data section. Click on [...] next to Control Source. Then I choose the field that I want. But, when I preview the report, I get...

Hi, I want to import an xls file in access. So I decided to import it in a temporary table, then from there, I would move them in my access structure. I know how to append a field using the action query. But, I don't know what to do when a reference needs to be inserted in the table. For...

cool, thanks a lot.

Ok, thanks.

So what would be the relationship between Printers and PrintTransactions? Is it many-to-one? "Printers have unique transactions"

But all printers print all the types of paper. So on the main table (Printers), I would end up with 4 references (SingleLegal, SingleLetter, DoubleLegal, DoubleLetter) for each printers. And if I get this right, that's a many-to-many reference. Isn't it ?

I thought quantities would go else where since it has many types of paper been printed. But since it's simpler, I'll stick with that. :) Thanks.

Hi, I want to create an access app that will allow a user to see the number of pages printed by various printers. These are the data that I have: Model Type (various are available) Printer's name (unique to one printer) IP addr (unique to printer) Quantity printed (such as Single Legal...

Hi, I have an xml which fields of text and some of numbers. When I do: File --> Get External Data --> Import; I'm able to import the file. The problem is that not all the data is entered in the fields. The colums containing the text are excluded. While importing, I did choose the option...