Search results

You are using this in the query design, right?

Hmm not sure why that didn't work, but try this. IIf([place_detail]="Home",Replace([place_detail],[place_detail],"Not Applicable"))

Your DB sounds similar to mine. You will need to call that function each and every time you want any of those things to happen. Perhaps validation would work. After Update of each control, check to see if any tagged control has a value of null. Upon having no nulls, call the function. Also, I...

IIf([place_detail]="Home","Not Applicable",[place_detail])

Or, if each item has an ID, you sort by ID and hide column 0.

This could be useful for many things. In addition to broken references, to check if the back-end server is available, to check if an admin has locked it for maintenance, etc.

In Excel I do a MATCH, assign a number to each line on one side, then do a Sort that lines them all up. It's all recorded in a macro that is very specific to the input format. I've contemplated moving this to Access as I think it could do a better job, but it would take some work to set it all...

If your data is standardized between the two, you should be able to run a duplicates query that shows which values exist in both tables. Is it okay if this is a two-step process? 1. Run unmatched query, 2. Run duplicates query?

A good first step, but you need foreign keys in your tables (such as an OperationID in tblConsumable) that will hold any records from the many side of the relationship to tblOperation. Then create a relationship between the PK and FK fields that are equal. I would also be clear about what...

It was a reply to:

Maybe in the No Data event: Private Sub Report_NoData(Cancel As Integer) Cancel = True End Sub

Look up "one-to-many relationships". For each Operation, you can have many Consumables. So tblOperations All the things that there is only one of: If there is only ever one Operation Date, Operation Name, Patient Name, then those items stay here. However if an Operation can ever span multiple...

https://abcnews.go.com/Politics/intelligence-report-warned-coronavirus-crisis-early-november-sources/story?id=70031273

Yeah...if we could press pause on the Limbaugh and Jones for a while, that would be great, mkay...

Pat, Since we're on the topic, do you believe that opening a form with a WHERE condition (DoCmd.OpenForm, etc etc) is functionally equal in performance to adding a criteria to the form's query designer? When adding criteria and checking the SQL view, it adds a WHERE condition. What we want to...

As theDBguy alluded to, this approach is only needed for an unbound form, which is maybe not what you were going for. The first error is caused by trying to save the primary key to a record that already has a primary key - because of the default autosave functionality of Access. The second error...

I have run into this a few times and was about to pull my hair out after not finding anything wrong with my queries or form properties (as in, I knew that value was not needed but I couldn't find why it kept asking me)...until I found I had a text box somewhere on the form looking for that...

I use this approach or use a WHERE condition that is different depending on the button clicked.

The combo box wizard (that appears when adding a new combo box) walks you through this step. I'd recommend doing that to see the process. Afterward, you can click the 3 dots next to the Row Source in the property sheet of the control to edit the query that the wizard created.

I haven't used the methods in the video, which is indeed the long way around the barn. My simpler, or lazier, method is to use the font ABC Code 39 Regular. This is of course for a certain type of barcode but is functionally the same as those in the video. Then I simply wrap the cell I want a...