Search results

Try this *********************************** Private Sub HomePageEvents_Change() If Len(Me.HomePageEvents.Text) > 375 Then Me.HomePageEvents.Text = Left(Me.HomePageEvents.Text, 375) MsgBox " You reached the Limit!", vbOKOnly, "" Exit Sub Else End If End Sub

Theoretically, you shouldn't have any problem. However some more details are needed before specific help/guidance can be given. 1. Will any data be entered or edited in the ODBC tbl1 table? 2. Does the data in the ODBC tbl1 table only relate to the Leader? 3. If the ODBC tbl1 table also...

Creating Relationships Sample of Database I don't see any forms in the sample database you provided. Seeing you data entry from may help in solving your problem.

Creating Relationships Sample of table changes Here is my change to the table structure

Creating Relationships - "TblKwaliteitgegevens" table Is the "TblKwaliteitgegevens" the table that defines the "CatagoriesID" field in the "TblKwaliteigegevens" table? Are these Definitions unique to a Machine? Or are they definitions for the "CatagoriesID" for all machines? If they are for...

Creating Relationships - "TblFrequentie" table I would change the Key from the "FrequentieID" field to the "Frequentie" field and make the "Frequentie" field unique and required. It's not the number of the "FrequentieID" field that is unique (Indexed - Yes (No Duplicates)), its the "Name"...

Creating Relationships - "TblKwaliteigegevens" table I'll look at the tables post my remarks as I finish. First, in the "TblKwaliteigegevens" table, the Field "CatagoriesID" serves no purpose. It isn't tied to another table that defines it or limits the possible entries. As it currently...

I agree. If you have a "Rule" that says if X=KKK and Y=ppp and Z=uuu then W=0 why not just use code to enter a "0" for W and lock the field? That way you can't have an error in your data. PS This would be done on the form via VBA code.

Do you have a paired down version of the database you can attach to this site? It'd be easier if I could look at the database.

Use the word AND instead of the &.

In general terms, you want to reduce the "manually entered" data as much as possible. So, for any field that can be "standardized into a seperate table, do so. For example, if you are a military organization you would want to create a table for all Ranks (let's say tblRanks) with two field...

I have a form with a list box, set to "Simple" Multi-Selection. I want to be able to filter reports based on the "Items Selected". I can create a VB Function to "gather" the selections but can't seem to "pass" this to the query. Does anyone have an example of how the did this? This is the...

Can you post your code? Are there multiple tabs? How about pasting a picture of the form?

OK, I've added a way to access the underlying CrossTab Query so the user can export out the raw data. However, if someone can/is willing to take a look at the database attached to the first post and give me some assistance in changing the report selection to look back at the ServerList listbox...

OK. How about if I place a call to a module in the server name field and use the following. Shouldn't it give me the string value of all the servers selected? Unfortunately it doesn't. What am I doing wrong????? Dim frm As Form, ctl As Control Dim varItm As Variant Set frm =...

So, there's no way to "cycle" through the report again for the next set of 20???

I've created a report that fits on a Legal sheet of paper. I use the code below to "stuff" the data into the report. Unfortunately, I'm limited to 20 columns. Is there a way to print another set of 20 and then a nother set of 20, etc. until I reach the EOF for my record set. I have may users...

Thanks to Jason on the Novell NSure Audit forum (which is the program were the data came from), I used his function (slightly modified) to calculate the IP addresses. I used the following formula on forms and reports =IIf([SourceField]<>0,fnIPConv(([SourceField]))) These formulas call the...

Does anyone have code that will convert a DEC number to and IP Address?

Why not create your "Report" PO in Access then save the PO as a PDF and Mail the PDF file?