Search results
-
Make Table Query - setting Table properties?
Good point Pat. Thanks for clarifying the Db bloat issue. -
-
Hyperlink Insertion
You can do this, if you format your mail as HTML format. Unfortunately, not everyone can accept (or chooses to accept) HTML formatted mail. If you understand HTML, it is fairly easy. If not the basics of the HTML Document are <html> <head> All head information goes here - metatags etc </head>... -
Appointments with three types of roles
Good point Doc, thanks for the correction. :o -
Make Table Query - setting Table properties?
Thanks Pat, I did not realise that deleting rows created bloat but I knew that the space could not be recovered until compact. However, surely making and deleting a table will cause irretrievable bloat whereas with deleting records, the bloat will be 'recovered' during the compact process, or is... -
-
Hyperlink Insertion
Depending on the e-mail client, some will automatically parse your address as a hyperlink and not text. To force this, use the file: prefix eg file://X:\subdir\file.xxx or file://\\server\subdir\file.xxx This should do it. -
OnNonInList and concatenate fields
You can do this via code but it is a bit more tricky. Essentially, if you want to add more than one field, you need to split NewData into its separate parts and then add the 2 parts separately. eg if you type Smith, John into the combo, the code would need to do the following Split "Smith... -
Repeat a record a specified # of times on a report
The only method I can suggest at the minute is by using a temporary table as the basis for your report. To ensure that the right number of lines are produced, use a looping recordset to add records to the table based on the quantity field. If you are unfamiliar with how to code this, get back.- Fizzio
- Post #2
- Forum: Modules & VBA
-
Make Table Query - setting Table properties?
If your table always has the same structure, why not keep the table but just add and delete the data. Add via an append query (as you are doing) Delete via this SQL DELETE * FROM tblTableName; I would choose to keep the Table in place rather than create and delete it with each run as this... -
Instr
Sounds like you have an inefficient structure if you are having to carve up a field to do the comparison. I'm sure (if today is your deadline -tut tut, leaving your homework till the last minute ;) ) that you will not want to embark on a restructure. Therefore, post an example of what will be... -
Appointments with three types of roles
In the most simple of versions, you simply need another table with Appointments in it. Your structure depends on how much interactivity there is between the 3 roles eg Does a Client meet with a Doctor? Can any of them meet with one (or more) of the other or do they meet with other people... -
Combo Box v. List Box
Queries really give you the power to get out of your database what you put in in almost any permutation you want! Hang around the Queries forum for some posts and maybe look on the FAQ for some useful links. I cannot think of a good link off the top of my head! You can display multiple colums... -
Checklist How-to
I'd like to see it working if you get the listview control bit sorted. Can you post if you get it working with the listview? -
Combo Box v. List Box
This can be tricky depending on what you are trying to achieve. Have a look at the demo I have posted for the 'easy' and 'advanced' forms which shows a slight difference in the third listbox Easy - lists all components of a course Avd - lists only the components a user has taken from the... -
Lookup??
Think carefully if you need to actually store the information in a different place or just need to display it. There is no reason for storing the same information twice in a Db (violates 1NF) except if you are stipulating a delivery address (for example) that may or may not be different from the... -
Checklist How-to
If I read you correctly, you want to display all steps and then allow the user to check off which of them have been completed. This is actually quite difficult as a typical form/subform will only show records that you add, not records that are added as default and then shown. How I have got... -
Combo Box v. List Box
Your structure is ok but you have not described what you want your cascading lisboxes to do :confused: -
.visible giving strange results in on current event
Glad to see you came clean eventually ;) I get into the habit of occasionally importing into a 'fresh' Db just to keep this bloat down and always before distributing a new FE. Glad it is sorted :)- Fizzio
- Post #9
- Forum: Modules & VBA
-
Last Record in Combo Box
If you format the date in the underlying query, it will show the format in the combo box ie DateMonth: Format([YourDateField],"mmmm yy") to move to the last item in the combo use Dim intX As Integer intX = Me.YourCombo.ListCount Me.cboName = Me.YourCombo.ItemData(intX - 1)