Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cimoli
  • Content: Threads
  • Order by date
  1. cimoli

    Best password method with time factor

    8/19/22 I have read many posts about this topic but wonder, which is the best one for me. I have an Access database and need protection but do not want anything too complicated. I am thinking, give me ability to change the password say every 3 months. And prevent someone hiring a knowledgeable...
  2. cimoli

    Lock in YES answer for 3 queries.

    I have a good working Form button. However, I am asked 9 times to answer YES when 3 queries that are inside the button, ask like, you are about to override, etc etc. A dialog thing. The 3 queries create 3 make tables. I will always answer yes. Is there a way to permanently lock in the YES...
  3. cimoli

    ZOOM box crashes my Access file.

    I have the following in a text box on a Form. I can enter the data but when i doubleclick to open the zoom, i am kicked OUT of the file in the Windows 10 Lan. This text zoom box worked for fine for 10 years. thanks you for your advice. Private Sub txtResNotes_DblClick(Cancel As Integer)...
  4. cimoli

    Access Query IIF statement with multiple conditions

    I have a query criteria combo box to use for choosing a Trip. All works well except for one condition. I would like cboResTypeID 19 to use the trips for codes 14 or 16. I get nothing if i use code 19. IIf([Forms]![frmReservation]![cboResTypeID]=19,([tblTravelMain].[ResTypeID])=14 Or...
  5. cimoli

    Opening the same file twice on the same computer.

    Just found a worker opening the Access file up twice on his computer. Then he searches for records in each. I assume that this is bad. He crashed us today. Is there anyway to prevent the person from loading up the same file (let's call it Jones.accdb) on his computer?
  6. cimoli

    Can Access 2010 and 2016 coexist in my tiny Lan.

    I have Access 2010 on a main server and 6 stations. Using Windows 2010 ver 1809. We bought 2 new machines. Put Office 365 on each. Copied the Access 2010 accdb file onto one of the office 365 machines and it works fine. If we linked the 2 new machines into our tiny 2010 server, will...
  7. cimoli

    Access 2010 is crashing after Windows 2010 1809 update in Lan

    We have had Access 2010 crashes often the past 18 days. 3 times, all the qry, forms, reports, mods etc disappeared. And the tables were suspect. This started when we got rid of 3 computers and added 3 new ones with windows 10. We have 1 server and 6 workstations. I have read about 2 Access...
  8. cimoli

    How can I have text box report name get inside my form button?

    I would like to replace the Dlookup that appears in the On Click Events procedure. The purpose was to lookup the report name for a given place. Instead, I have figured out how to get the desired report name to appear automatically in the same form in a Text Box using ...
  9. cimoli

    Windows 10 Lan and a Comcast phone

    I have had many Lan crashes which then crash my Access file. Severely. I noticed today that the owner has a Lan wall cable from the PC to the comcast phone and then a second cable from the phone going into the PC. In other words, using Comcast's internet phones. On each desk except the...
  10. cimoli

    Access corrupt database error message

    11/23/2018 We used MS Access 10. We have a small windown 10 Lan. 6 computers. We changed the Windows XP server to Windows 10 and now all 7 computers are windows 10 and Access 10. We are getting a sporatic message that the database is corrupt. We get out. Go back in, and it works again. The...
  11. cimoli

    Image path for 3 computers. How to control?

    Our historical society has 3 people who use their home windows notebook. We plan to put the Access file and the Image subdirectory onto a passport flash drive. Then the 3 people take the passport home and I would have a batch file automatically refresh their harddrive. The problem will be that...
  12. cimoli

    Link two Forms

    I am having trouble making a command button on the 1st form pull up a 2nd form. The common field is called ReservationID. The code below calls up the 2nd form but it is blank just showing the fields with no answers. So it almost works. No error messages. Can you see my mistake? Thanks...
  13. cimoli

    Form Buton to clear Y/N field in 5 tables.

    I have a main form with 5 subforms. I use a yes/no field in each of the 5 underlying tables to manage my picks per subform. EG I checkmark a few customer type in the first subform. I checkmark cust classes. etc. However, I need to reset the 5 subforms to have an empty y/n when I am done. I...
  14. cimoli

    Query criteria cannot find a subforms unbound field

    I am having trouble getting a subform to be recognized with a query and after update. I want to stay with an Access criteria query and avoid vba and sql. I will first show you what works and then the part that does not work. 1 - If I put my unbound lookup fields on the parent form and use the...
  15. cimoli

    Should I set Unicode to Yes for my text fields ?

    I have been reading about how to speed up Access in a windows 8.1 Lan. I found an article that recommended in the tables that are text, to set the unicode to Yes. I looked in my primary table for customers. I see that all my text fields Unicode's are set to Yes exceot for a couple that say...
  16. cimoli

    Button to Reset a Form

    I used to have an Access button that would reset my form after a search. I must have done something to make the button not work now. I have 19,000 form records when I start. I hit a different button that gets me a particular TripID. Then I get correctly 42 records. When done, I would like to...
  17. cimoli

    Error Message needed

    Hi. I would like to have an error message appear if my Form frmReservation combo box field cboLookResID cannot find a reservationID. I currently use just the 3 lines that start with the me.refresh in the afterUpdate. All works fine to retrieve a valid reservationID. However, If I enter a...
  18. cimoli

    Control source calc error

    I am getting #size! in a form field. In the form field control source, I have, =IIf(Nz([BowlingHistory])>0,Nz([BowlingHistory]),0) BowlingHistory is a number. The number is typically 0 to 800 but can be any number. I thought my formula in the form control source would place a zero whenever...
  19. cimoli

    RecordSource error in After Update Event Procedure

    I am trying to make a fancy After Update event in a lookup field that is on a main form. I am kind of trying to make a template for myself. Can you review and see my mistake? I tried 2 methods. The 1st method WORKS and retrieves One ID and all the fields needed. I have a criteria in the...
  20. cimoli

    Need a calculated field looking at 3 date fields in query

    I have a working calculated field in a query which compares 2 real date fields. However, I am introducing a 3rd date field. I do not know how to change the calculated field to look at all three dates. Here is what I presently have and it works. It uses 2 date fields. StartDateIn and...

Part and Inventory Search

Back
Top