Search results

Checkbox is invisible. Not seen by the user, not clicked on by the user. I am using a checkbox because the toggle switch cannot be made transparent. Instead I am using a transparent button. When that transparent button is clicked, it changes the status of the checkbox so the IIF code can...

That's not a bad idea. Anyways, can you explain how your code relates to what I am trying to do? I am not very experienced with VB yet, but I am always trying to learn when I can, and I know you are one of the best programmers in here, as I have used your advice in other people's threads many...

I'm honestly not familiar with the purpose and function of the not me. checkbox code. User will NOT be clicking on the checkbox, they will be clicking on a button that cycles the checkbox on and off. More: The checkbox is null when the form opens. It has no recordsource. It is only being used...

No. I used : If IsNull(Me.Check219) Then Me.Check219 = True Else If Me.Check219 = False Then Me.Check219 = True Else If Me.Check219 = True Then Me.Check219 = False End If End If End If End Sub

Nevermind, figured it out. Duh...

No I mean something to the effect of On Click If RemoteCheckbox= True Then RemoteCheckbox = False If Remote Checkbox =False Then Remote Checkbox=True

I am making a specialty form where it must toggle on or off when the user clicks on a boxed area. Since toggle backgrounds cannot be set to transparent, I need to do it some other way. I thought of either using a button to control a hidden checkbox, or just writing code altogether. The problem...

I am pretty close... Can anyone tell me the VBA reference that returns the name of the current database (the one I am using)? I am going to use that with the .laccdb on the install path to confirm whether the file exists or not. That way it will specifically look for my database.

Thanks, I will look into that code. I could have that automate on the close event, therefore only doing the back up if nobody else is on the db, ie: when the last user has updated it.

Hi all, Kind of long- winded, but I want to get this right before I deploy it. I am re-employing an Access 2007 database that I designed a few years ago, after making numerous improvements. This database is 3 tables. 1 table is personnel, another is files, and they are joined at a table...

I am using a continuous form which is strictly for reference (user enters no information.) It is a list of names from one table, and to the right of the names it has a spreadsheet appearance with a box conditionally formatted based on certain events for each day of the month. (Customer insists...

This is a continuous (query-based) form with recordset combo boxes in each row. The text to the left/recordset of the box is a list of jobs. The combo box is the method of selecting the user or users who will do the job. The combo box criteria is based on 2 checkboxes to the right which decide 1...

I am well aware of all the capabilities of the combo box properties, and I went through all of them while I was trying to find a solution. I need the user to be able to change the selection, just not click on the stagnant text next to the drop down arrow when it isn't being triggered. You would...

I have 3 HUGE 500+ page Access manuals that all have the same exact damn database examples in them in regards to the basics of forms, queries, and table structure. I have been designing much of my database project automation using macros and Expressions. I know the basic rules when it comes to...

Because if it is locked or disabled then they cannot click on the combobox dropdown arrow and select records. I still needed them to be able to select records with the combobox. A locked combobox is pretty useless.

Thanks; I will do some research on OpenArgs. I work in a trusted organization where SSN's are the only common way people are identified; otherwise I wouldn't use them.

I figured this out today...after searching everywhere with no avail. I didn't like limit to list property because users could still click on the control. Also, due to the code I was running, clicking on caetain combobox text in my continuous form caused a repeat of the original IIF conditions...

BORING PART: First off, I wanna say thanks to the help I have had in the past. I heard that my first database is still in full use without a hitch, and has just passed its 2 year anniversary. This forum is a godsend, and without you guys' help it would not have been so successful. I am still...

Still kind of confused how to move it out of the loop. I've been messing with it for 5 hours now and not getting anywhere. Keep in mind I'm a complete newbie to VBA. I think there is some way to do it within Access, although I've found many unanswered threads on this topic. I did find some code...

I am really new to VBA; having gotten by designing most of my database with macros so far. I have a query that I designed that pulls up a list of people and their email addresses, as well as 4 other fields of information. The query has no Nulls anywhere. I need to send an email through Outlook...