Search results for query: *

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...

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...

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)...

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...

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?

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...