Search results

Obviously something else is happening. It is easy to set TR_3 to visible = false, but something else is changing the data. What is it?

This is what I have so far, without any CSS formatting: Public Function HtmlEmail(strReportName As String) Dim objFileSys, objTxtStream As Object Dim txtHTML As String DoCmd.OutputTo acOutputReport, strReportName, acFormatHTML, "D:\temp\" & strReportName & ".html", False...

Are you saying to use an append query to append data to the open subform's query?

@gimo: If you put a stop in your loop: For Each ctrl ... Stop Next ctrl It will loop once, then stop. Then, use the F5 key to loop again until a control throws the error, or user F8 to step through the code one line at a time. Just to make sure, these 'newbie fields' are actual controls on...

Thanks, Cronk. I haven't gotten as far as adding tags in the body string, was wondering if they would come out formatted. I'll have to try that today.

Has anyone had success creating a master form that shows you who is connected to what database, allow you to send a message to users, kick users...? I have seen a picture of one posted a while back, but no details were given on how to do it. I will have my second database online in a couple of...

Hi, I would like to create a decent looking email using VBA to customize To, From(based on User Name), Subject, Body. I can get a simple text email to send, but I would like to format it a bit better than using crlf and spaces to align words. I see that we can set the body type to HTML, but I...

Hi all! I would like to copy data from one form to a subform on a separate form. The user wants to place an order, so he clicks a button that opens a form with datasheet to search for something. A checkbox is on the record of each item, so he can select multiple items. Then, click button to...

@Gimo: Sounds like you have a missing .dll file. Perhaps you tried to customize your mouse's behavior in some way? See this link for some additional info.

Much reading is good for the mind. That is how I have been learning Access, SQL and VBA! Also, try using google advanced search for this site and others like it.

What are you trying to do with the text boxes? What is the relationship between the two boxes? If you have an event that fires every time the value of either box changes, for both boxes, then you're going to have problems. What other event code is going on?

Very interesting, Mark. I would like to know what p0 references as well. I've never seen that, and I like the use of aliases, as well as the SQL Const. Mike

Well, I used a table to store the controls' name, and additional fields (y/n) to store whether that control should be enabled based on another variable. So now i can log in as any user and click on the Edit button and only those controls are enabled.

@Cronk: What do you mean by 'storing the control name against the UserID'?

Suggestion: Google listbox members. The MSDN site, along with many others, have a ton of useful information. The RecordSource is from where the control pulls its data. The ControlSource is what it is bound to - what it reads from and writes to. You can set a variable = listbox.column(index...

@Cronk: Incidentally, I do have the users in groups (levels). But there remain situations where a low level user may or may not be able to edit the Order data - determined if that user is the creator of the order, and if the order has already been approved or ordered. Also, the higher level...

Why don't you try using something like this? See pic. Using combo boxes to filter your datasheet, then select your record and get the details below. Otherwise, you'd need to add a click event to the listbox, get the PeopleID from that column, and set the frmFamily record, I think, to that of...

Hi all. I am using one form to create new records as well as view existing records for review/editing. I have all the controls disabled by default, and only enabled based on New Record, who is viewing the existing record, what the status of the record is and what department the users are in...

why don't you post a sample database and describe what you want to do, from start to finish?

Yep, it's the form's fault. lol Thanks guys!