Hi, everyone! I have a simple question I've made a database with a five similiar tables. All of them has two fields: id (Auto number), name Text, 40). I made a...
I have a form I use foe editing data in my tables. On certain field changes I secure those changes & flush out oldvalues by using Me.Requery This works fine,...
Refresh Method The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to...
You can use Bookmark property.Open any VBA module and seek help on Bookmark. You can try the examples to see if you can acheive your goal. HTH Liveson ... ...
I have a mailing software and trying to use now rich text box as the mail editor. I managed all kinds of fonts formatting and alignments except Justify. I...
Dear NG - I'm very new to Access and would appreciate some guidance. My table looks like the following: Year County VarA VarB VarC etc. 1982 Athens 900...
Dear NG, In an earlier post to the group, I was trying to find and easy way to calculate %change estimates between years for a group of variables. My data...
I'm getting a really odd error, it only happens sometimes on a really simple output macro. SetWarnings = no, OutputTo: Query, Query Name = Final Export….....
I am having an issue with updating a table based on a form. My database contains tblInfo, tblData and tblWarranty. I have a form which contains 2 serial...
You could set up a form then use 2 combo boxes to select the years to compare and 3 text boxes to display the output. These could have 4 columns any of which...
Hi. Rather new here. Below is an Access 97 VBA subroutine. I am having a problem with the lines - "AND SaleComps.[rptdate]>=" & Me.bminrptdate.Value & " " &...
Hi, The rowsource property of the combo box on a sub-form which is in datasheet view doesn't change as per the selection in the main form. What could be the...
Hi. I have an Access 97 query shown here: SELECT SaleComps.* FROM SaleComps WHERE (((SaleComps.City) Like [Enter City] & "*")); This allows me to enter the...
Group, I have a query that is returning the correct results I am looking for. However, when I export the data from that same query it is returning extra...
Private Sub Cmdcity_Click( ) Dim db As Database Dim qdf As QueryDef Dim strSQL As String Set db = CurrentDb Set qdf = db.QueryDefs( "results" ) strSQL =...
Im using the above controls (shdocvw.dll) as my HTML email editor and managed most of the standard formatting. Below are the remaining issue to me and really...
PS. Also instead Cntl+Enter just Enter only for creating a new line. TIA, George ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On ...
Glad I could help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==>...
Does anyone here has a very straight forward code to upload a file? I been looking for this for year but still didn't get a solution. I read about Windows API...
Dear NGs, I recently downloaded and read a bunch of material on normalizing your data and db design. Things aren't crystal clear yet! Part of the problem is...
(Your Name?) The presentation of the information is not as relevant as the collection of it. From what I understand below, your Table A and Table B are really...
Brett - First, thank you for your time. I sincerely appreciate the help. Second, my name is Mike. Third, I've got to run here in a bit, but I wanted to thank...
Hi Guys, I am suddenly finding that my query fields have all turned into Expressions. I am using ACCESS 2003. I turned on all the options under Name Auto...
Sorry Folks, I have worked out what I did. In my main switchboard form I establish links to my tables on opening the form and before exiting the system I...
Re: deer data collection. I havent followed if there is a form to enter the information so I am just wondering how this data will be inputed using a form....
Hi Guys, Using VBA: How do I inhibit the display of the Database window? How do I suppress the message "Existing table will be deleted before query"? I seem to...
I currently have a program entirely designed in MsAccess and would like to take some of the larger tables and convert them into SQL instead. Can anyone...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
