Search results

First of all, thanks to everyone for participating in this site. It has been the most helpful by far that I've come across. That said, I am seeking assitance yet again. I am trying to do something of a lookup function and am not sure where to start. I have a field on my form called booktype...

Progress: I've inserted a stopwatch as a subform (frmTimer) on my main form (frmTicket). The subform has three buttons, Start/Stop, Save, and Reset and an unbound field (ElapsedTime) that displays the elapsed time. The Start/Stop and Reset buttons are self-explanitory. The Save button takes...

Wow! I really thought this was going to be so much easier! I've read through just about every post and thread referencing list boxes and really can't seem to find a solution. Situation: I have a list box (listboxA) on my form (SelectList) that displays a list of values from my table...

Good Day! I seem to be running into a calculation problem in one of my queries. I have two fields in the query, AdmitDate and DischargeDate. I built in an expression, Exp100 to catculate the date diff in days between these two dates. Now what I want to do is display a count of the grand total...

I want to build a form based on a query, but I don't seem to be structuring it properly. Please refer to attached picture to help explain what I'm trying to do. I have 4 essential fields in a table, tblInpatientLog. They are POSno, Primary, POS Code, and Length of Stay (calculated as...

I must be missing a reference somewhere, but I have a form with several calculated fields in it, with the control source as =DateDiff.... They were working fine last week, but now all it displays is #Name?. What happened? I've looked at my references and none appear to be missing. WHich one...

I'm sure this one is easy, but I can't seem to get the code to work right. I have a field called "Discharged" and "ProposedDischargeDate". What I want to do is if the "Discharged" field is empty, or null, I want the "ProposedDischargeDate" to be visible. Otherwise, I want it to remain hidden...

I'm having some trouble developing a query based on a specific date criteria. I have a date field, called "SurgeryDate" with 4 fields next to it, "3Month", "6Month", "9Month", and "12Month", which are auto calculated with a control source of =DateAdd("y",+90,[SurgeryDate]), based on the date...

I searched the forum and realize that there are many posts on this subject, mostly related to exporting the data on reports and such. However, the problem that I am having is within the form. I have two memo fields on my form, named Memo1 and Memo2. Their data source is on a table where both...

I'm really hoping this is just a little bit of code here, but here's what I'm trying to do, without success so far... I have a cascading combo box field called [Name], which is linked to a table that only has 3 columns, ID, Name, and Number. The combo box displays the Name column, with the...

I see a lot of really interesting ways to do this via code as an automated action, but what I can't seem to find is how to do this manually?? I will look into the automation at a later time and probably use some of these wonderful ideas. For the moment, however, I just need to know a simple...

Hate to throw this issue back in the mix, but I seem to be really struggling to find a solution, even after extensive searching through posts. I can't seem to pin down any existing posts that directly addresses my problem, so here it is: I have a DB that needs to be accessed by no fewer than...

Is there a way to open an Excel file in the background, run an Excel macro to format the data as I need it, then import/append data into my Access table all with one button click?

Alright, I know this must be one of the stupidest and most simple question of all time, but I just can't get my brain to work this out and have been searching through the forums for more than 2 hours with no luck. I built a report from a query based on a table. It looks great, all but for one...

This ought to be an easy one, and I had it figured out in the past, but I can't remember what I did before. I've tried so use the forum search, so I wouldn't have to bother anyone with this, but I can't seem to word my serch criteria properly. I have a cascading combo box for doctor's names...

I have the below code behind a button to merge and print into MSWord and it's working wonderfully. However, how can I modify it to print 1 copy of page one, TWO copies of page 2 and one copy of page 3? _________________________________________ Private Sub Print_Reconsideration_Click() Dim...

I keep thinking this should be pretty simple, but more than 2 hours searching through posts has revealed no answers, probably because the answer is too simple. OK, I have an append query. I've created a prompt to enter the number of the record the user wishes to append, as it is usually one...

Help please! I have a form (frmHalfTab) built on a table (tblHalfTab2) that has existing data in it. In the very near future, I will be uploading additional data to this table via excel cut and paste. What I want to do is search for and eliminate duplicate records that have duplicate data in...

Hi all! I'm looking for some help, but not really sure where to post this question. I want to put a button on a form (frmHalfTab)that runs a macro/module/ or VBA (not sure which will be the best approach) that will accomplish simultaneous tasks. 1) When clicked, I would like it to check the...

I just added a column to my table upon which a cascading combo box is built. When a name is selected from the combo box, 2 related fields populate. I want it now to populate a 3rd field. So I added the column to the table to input the data into that 3rd field, and adjusted the column widths...