Search results

I am trying to apply the following behaviour to a label formatted as a Raised Label (Label1) in order to make it mimic a button: I have a label with the 'on click' macro set to exit the form. I want to create a bit of code as follows: On Mouse Down: - I click event the button to choose the...

I know I posted a similar thread in General: no one has read it and I think I need an expert. Hopefully will find one here. Totally confused. I have a database that is on a server, populated with a bunch of data and forms. There is a security file associated with it that has 10 different...

All my data has completely disappeared in the main and back up db! What happened? I have a database that is on a server, populated with a bunch of data. There is a security file associated with it that has 10 different logons, each with special accesses, as well as an administrator password...

Have no idea what happened. I have a form. Assigned a little code to lock certain fields on certain criteria. The form stopped allowing any and all edits. Don't understand how the code locked the entire form, it was very specific to just certain fields but, nonetheless, I deleted it all...

I have a field for "projected budget" (is "0" prior to entry) and "final completion date" (is null prior to entry and is date format after update) that I would like to have editable only once. The condition I'm envisioning is that the field is updatable IF the value is Null (or zero, or...

I have a workgroup set up with users. I have a form for updating projects which contains records for all users. One of the fields is "Project complete"? I want this record to be editable/updatable only for those that the current user is the project owner of. I want the field to be 'locked'...

I'm open to different suggestions... Is there a simple way to make a database web accessible? To be able to add data, run reports, run forms, etc? How difficult is it? Thanks for any opinions!

Good Morning; I posted here because I figured this was where I would find the most professionals. I have over a decade of experience in writing databases & related reports (no VBA, all macros, forms & queries). I've been offered a 'contract' of sorts to write a very simple inventory mgt...

Here's one I cannot get my head around. I have a list of order numbers to follow up. I want to pull related email records to the list of order numbers. Each email record consists of a long field of text, where the order number may or may not be. Therefore: I want a query that will display...

Hello, all; I think this is probably a simple solution for some of you. I have a database containing records for which I need to set dates to follow up on. I would like to ensure that the date that is entered is a business day (So that when I run my follow up report for the day - I don't...

Does anyone know how to design a subform that can be plopped on a main form to find records? I have a customer table, and I want to be able to find a record by typing in a keyword from the customer name on a subform that is next to the main form......important that the entry does not have to be...

Hi, All! I have a report that adds up the total number of items sold, and groups by item. So, I've sold 18 of part a, 25 of part b, and 100 of part c. How do I sort by the calculated field (which I've named Sum Total) so that highest sold items sort at the top? Any suggestions?

Can someone tell me how you attach a database to a forum post? Thanks.

Hello, all. I have a table that contains a field (list) for categories [Inquiry Type], and a field that tracks category of any follow-ups [FU Inquiry Type]. The rule is: If [Inquiry Type]="F", than [FU Inquiry Type] Is not null. For some reason, when I'm entering data, the validation rule...