Search results for query: *

I have a datasheet input form. If the user tabs to the next record but nothing is entered the record shows as dirty on save, add, close, etc and an error script pops open until the user manually clicks in a previous record. It is annoying to always get this message but necessary for data...

I have cobbled together a query select * where ID1 OR ID2 OR ID3 = 5 but I can't get the query select * where name="Test" AND (ID1 OR ID2 OR ID3=5). I can't get the AND filter to work the results of the ID OR Filter. Thanks!

Is there a way to use the DoCmd.TransferDatabase acLink to an OLEDB provider. I can get it to work with ODBC, but not OLE. I want to be able to switch between multiple databases on the fly without having to setup multiple ODBC connections. Thanks

On a form in Datasheet view I have a script that saves the previously entered combo box value to strItemID after update. When the next record ItemID combo gets focus, it automatically fills in with the previously entered value of strItemID. The problem is that there is then no way to add another...

I have a NotInList issue. I want the value to be added to the list...which it is and then automatically filled in. So where it says ctl = Empty, I want it to say ctl = NewData. The problem is that the bound column is an autonumber, so NewData may be Bob but the unique TestID for Bob is 5. How...

I know I can alter table to increase a char(10) to char(20), but is there a way to go the otherway and reduce the field size as long as the data in the field still meets the new char size? Thanks

I have a list of Projects that I pull from a SQL database. Table SQLPR. I don't want to mess with tblSQLPR or the database, but I need to add some more fields like line length, line size, project type etc. so I created an .mdb file. I want the project list to always be current but I can't figure...

Not sure what I am doing wrong here... I have a report and in the detail section I have a lot of fields, a photo and a subreport. It won't all fit on one page, and I want to tell it where to separate with page breaks, but when the Detail secion expands over * 8.25 it totally messes up the...

The mshome workgroup keeps popping up in my network neighborhood but I can't figure out where it is coming from. It's probably someone plugging in a laptop from home, but I want to back track who it is since this is not allowed. Any suggestions?

I can't seem to get a combo box to refresh after the value in it is changed. Its a not limited to list combo box, so when the user changes something I want the list to update. I have tried onchange, on lost focus, on not in list, etc with no good solution.

I can pass a parameter from the button click which opens a report which has this function referenced in a text box. Function MHList(rept As String) Dim oRS As Recordset Dim sDistinctSQL As String Dim sGeneralSQL As String Dim sRecord Dim sWONum() As String Dim i As...

I have a function that needs to get the report name of the report that its being used in and I can't figure out how to do this. Here is the function. I have commented out the parts that I can't get to run, but might show what I want to do. I want to be able to use this function in multiple...

Is there a way to determine how many emails a receipient sends or receives in a day...or the header information on the emails that a receipient sends and receives?

Is there a way to stop the Not in list Error message from popping up? I know the answer is in here, but the searches keep bombing on me. Thanks!!

I have results from a query that I want to appear on a report separated by commas. qryResults a b c d e Report Field = a, b, c, d, e Thanks!!

I have a form that has a field called Node. I then have a another form that has a ToNode and FrNode Field that combines to make a ToNode-FrNode=LineName. On the Node Form I want to show all Lines associated with the selected Node. So if a Node (C45) is found in the LineNames C45-B34 and...

I have several HP SureStore 40x6 and 24X6 DDS3&DDS4 backup units. I can not get the cleaning tape to be recognized in any of them. When an inventory is done, it always gives a 6096 and an 8020 bad media error. I am running ArcServe 2000 with at least Service Pack 4 on all units. We did not...

I have a front end database that can connect to different companies, on open I want to check to make sure that the linked tables are valid in case a specific company file has not been renamed or deleted. If the company file is missing, I want it to link to a default database. The tables in all...

I have a front end with all my forms/queries/reports etc and a few tables that will contain static reference info..tblstates, tblcountry, etc. The user specific data will be stored in two additional databases. This will permit updates to the front end with no interruption to the data in the...

I need to be able to select a file to link to. I have a front end with the forms/queries/reports in it and the user will need to be able to select from multiple backends quickly. File/Open/Select File/Relink I have a relinking function that works great if the front end has broken links, but I...