Search results

MODERATORS PLEASE: I tried to attach my database but no matter how small, just the essentials, no data, Zipped and I still keep getting the same error message: " The Uploaded File Is Too Large " No zipped is: 14,336 kb Zipped is: 9,130kb Good [morning/afternoon/evening] wherever in the world...

Hello Gurus.. SORRY NEVER MIND I FOUND MY STUPID ERROR PLEASE IGNORE I have been working on a form that believe it or not the Navigation buttons are pretty much a match made in heaven for the form, BUT... there is a point on the execution of the code that I NEED the navigation buttons to...

Hello all; I have gone thru hours a few articles in AccessWorld and a few youtube videos, plus countless google pages trying to find out why a SIMPLE task as hiding a subform just simply does not work for me. THIS IS THE FIRST TIME I AM TRYING THIS SO PLEASE BE PATIENT. my idea is that...

Hello ALL, I have a SUB, when I close a form that checks if there are any fields changed, if no field is changed then UNDO and close the form, if not save the fields, but for a reason I cannot comprehend when I finish checking the fields and my variable is set to "TRUE", comes back to my SUB and...

I have this little piece of code that for some weird reason today [FRIDAY] it doesn't work Dim ActualTime As Date ActualTime = TimeValue(Now()) If WeekdayName(Weekday(Date)) = "Friday" _ Or _ WeekdayName(Weekday(Date)) = "Saturday" _ And _ ActualTime >...

Hello ALL, I have a routine that allows my users [admins] to be able to see the password of another user to change/update, and I use a check box control, works super good, but I want to make it a bit better using MouseDOWN and MouseUP but my brain doesn't figure out how to do it. Here is my...

I have a split database [FE] and [BE] I added a new table that contains only 1 record, ID and OfficeName my users FIRST need to go thru a Login Screen. I need on the Form_Load [Event] of the login screen to look for that 1 record and do something like this...

Hello All.. I have a Form called frmLoginUpdate which is linked to my tblLogin, is a Continuous Forms, displays the LoginID, UserName, Password(hidden) AccessLevel and OfficeLocation, Active, then the Field [SPwd] (On the form is called ShowPassword, but the Control Source is SPwd [field on the...

Hello all, I have this same routine in another program and it works, but here in this one I have no freaking idea why is giving me the runtime error 13, Type Mismatch error. I know what is mismatch, but I checked the table and the txt field is the same thing, so I am confused. if anyone can...

Hello Gurus: I have a weird issue [not life and dead], I have a database that when I EDIT the record on a form, the user has to press a button to save, I do that so that I have the opportunity to check some fields that the end user MUST fill so I do a quick : "If isnull(XYZ) ", which works many...

Hello all.. Has anyone run into an issue with the union query button where no matter how you add the tables when you click on the button generates a blank page then if you try to run it, of course gives you an error: Invalid SQL statement, expected [etc] I thought it was my computer, but it...

Hello Gurus. I spent a pretty bad time trying to figure out why a simple line of code like this: Me.Filter = "[ItemCode] like '*" & Me.Search & "*'" did not produce any results, I spent a couple of hours looking online and I found out that sometimes you have to use "%" instead of "*", and...

Following advise from Moderators.. Some code in my 1st Program is from @arnelgp whom I respect a lot. I have attached a mock database, contains no valid information, but is similar to my final database. I do understand that there are many possible programming errors but for what is worth it...

FOR THE ADMINS AND MODERATORS: I wonder if it is possible for me to "ATTACH" the database I am working right now, I've been working already for 4 days in a task my boss wants to add to the project, I found a solution online (youtube) and tried to applied it to my database (is about logging...

Hello all: Have you ever been in a moment where you cannot find the most obvious answer to a simple question? That's where I am.. I have an issue with a particular continuous Form and verifying data without using a button and Using DLOOKUP.. I have a Table Of Users that will have a user Name /...

Hello Gurus and Good Morning/Afternoon/Night: I have a very simple program (my second one), I followed instructions to perform a Compact and Repair Database using VBA and a button so I tried: Dim Source As String, Dest As String, Result As Boolean Source="C:\MyData\BE.accdb"...

Hello ALL: I have my database for sharing as: Default Open Mode = Shared Default Record Locking = No Locks (I guess Access do the job here based on other posts) now this seems to be great, but ... then why should I NOT use: "Default Record Locking = Edited Record" and how can I check and...

I can see the smiles in many of you, but I just can't figure out what to do.... The problem: I have a form, and I have a specific record I need to retrieve, I am 100% sure of the ID of the record, I don't need to search 100's of records and display them, that was done already, this particular...

I Created a Subform based on a Query, it works fine, BUT: Everytime the the form/subform opens the subform displays all the records I set on the query, but the subform ALWAYS creates extra space at the end that certainly makes no harm at all, but is just distracting and is in the back of my head...

Hello ALL, Newbie Here. I created the combo box using the wizard from a small database called ZipCodesCal that contains ZCode and City The EU (end user) can pick a ZIP, and save that value to my database using the combo box. The combo is displaying the ZIP and the CITY as well but the combo...