Search results for query: *

Yes, it is split I will check this Thank you

I have a form and it does not pupulate on one machine. I can log this user onto other machines and everything works fine. No user can log onto this machine and have it work. I have checked references and all are there. Does anyone have any ideas?

Thanks for all you help I figured out how to see what group others belonged to and got him redirected properly He is working ok now. Thanks again

Thanks for the response Yes, the user is on the same operating system as everyone else. He had some virus's and I quarenteened all the infected files. I reinstalled several things, but just can't get Access working. I am assuming that everyone is joining the system.mdw on the server. The IT...

Yes, when he logs on he gets a series of error messages that say that the groups are not recognized. I pointed him to the system.mdw on the server rather than on his local C: and that recognized his name and password, but it is not recognizing user groups. Hope this helps.

I put a copy of the MDE on the local users drive by comparing the date stamp on that version to the date stamp on the network version. I have one user who has lost his link to the network security tables. I have tried everything I can think of, but can't get it back. Does anyone know what I...

Help, Will this work for existing fields in an existing report I tried Dim rotatelabel As Object Set rotatelabel = Me.lbl1 rotatelabel.OleData = Me.lbl1.OleData rotatelabel.escapement = 90 Any suggestions?

Thankyou Yes, you have the idea. The address field grows as needed, but the other fields do not grow to match the length of the address field. So the borders that I have around these fields do not line up with the address field. This is making the report look odd, I know how to have a line...

Is it possible to change the height of a text box in a report to match the height of a text box in another report. I have one field that creates an address - it may be 2, 3, 4, or 5 rows high depending on the amount of data. I have a border around this box. I have another field that has a...

An easy way to do this might be to add a time field to the table. Then you could run your report based on the time the information was added to the table. You could also add the user ID and then you could additionally report based on who added the record.

Depending on how complicated the querry is, I have had trouble in the past using between in the sql statement and have had to resort to using and Instead of between 1 and 6 >= 1 and <=6 For some reason, that works when I can't get the between to work.

One simple way would be to create a query that sums the information you need. Leaving the comment field out of it. For your report recordsource, build a query that uses the fields from the query you just created and add the comments. Make sure that you get all records from the query. Then on...

The formula in lotus 123 would be very much the same I would still put in something for the remote chance that E4 <> 0 and F4 <> 0. Things that are not supposed to happen sometimes do. =if(E4=0,D4+F4,if(F4=0,D4+E4,&quot;Error&quot;))

This appears to be an excel question and not a question for access. If I am correct the formula would look like this. In cell G4 type =if(E4=0,D4+F4,if(F4=0,D4+E4,NEED SOMETHING TO HANDLE E4 <> 0 AND F4 <> 0))

The file is saved as an Excel File. Most of the information is in the import file itself. The excel file has ShipToCode ShipToName ShipToAddr1 ShipToAddr2 City State Zip Item Number Qty Ordered Qty Shipped Qty BackOrdered Unit Price Extension Unit Cost Line Type Everything else is coded into...

I need to create approx 400 salesorders. All the same item, same customer, just different ship to codes. I have the list of ship to codes in an excel spread sheet. The ship to codes already exist in Mas90 for this customer. When I created the import, it runs, but it show 0 records imported, and...

I tried doing the same thing - can you view your code in SQL - maybe then you could see the difference. SELECT animals.*, IIf([animals].[pet] In (&quot;Cat&quot;,&quot;Dog&quot;),[animals].[pet],&quot;&quot;) AS Expr1 FROM animals;

Try [Animals].[Pet]

This is a very old thread, but it is exactly what I am looking for. Were you able to successfully do this? If so, can you share the form with me?

Thanks for responding M90 V3.31