Search results

Hi, I am populating a table from a query, I have made it an append query. Is there any way that when I run the Append Query it does not simply add more records but overwrites any existing data in the table it is appending to and then write the new records? Thanks. Fen How

Thanks Bob, No regrets, I completely agree. Let me see if I can get it to work. Fen

Hello, I have been through the forum and have not been able to find a clear example or answer. I have a form with a subform. I want copy both the form and subform data and create a new record with it. Any easy way to do this? I found stuff on Append Query but did not see any examples and I...

Hello, I am using this code I found on this forum quite some time ago. It has served me well. I was wondering if there was some easy way to add a check box that would allow a user to "Save" their username and password so they do not have to plug it in each time they go into the DB. This code...

Hi, I have a form with 4 txtBoxes on it. txt1, txt2, txt3, txt4 I want to add an unbound txtbox that shows the sum of txt1,2,3,4. Is this possible? Thanks. Fen How

Hi, Can anyone tell me how to export data to a .dbf file but prompting the user for the file name and location of the save. I have this code and it works but it is fixed as to the file name and location. Thanks. Fen How Dim access As access.Application Set access = CurrentProject.Application...

Hi I found this code and it works but is there any way to prompt for filename and save location? Thanks. Fen Private Sub Command276_Click() Dim access As access.Application Set access = CurrentProject.Application access.DoCmd.OpenQuery "qry_si EXPORT FOR MAP" access.DoCmd.TransferDatabase...

Hello, Is it possible to export a query to a .dbf file and be prompted for the file name and save location. Fen How

Hi, I have a listbox on my form that is calling data from a table that has option values in it 1, 2, 3 etc.. I am using this code on my form to convert the numbers into words =IIf([si_Permitting_Status]=1,"Permit Assigned",IIf([si_Permitting_Status]=2,"Permit Pending etc... is there anyway...

Thats it! Thanks a lot. Nice job. Fen

Hello, Is is possible to run an update query but prompting for the value that all records will be updated to? versus having a fixed value in the "Update To" area? Thanks. Fen How

Hello, Have a txtBox on a form, data is a value 1 or 2 based on a check box selection in an option group. Want to show Completed versus 1 and Not Completed versus 2 in the txtBox on the form. I seem to recall some kind of conditional format I could apply to the txtBox using an expression but...

That was what I needed. Thank you so much. While I have you, what would cause records to sometimes corrupt and fill with what appears to be Japanese or Chinese? Fen

I want the last bit to be a part of the entire Sub, so if This is the case If Me!Text214 < 1.66 then the respective happens but if this is the case : If Me!OWNERINT = 1 Then it trumps the other. Thanks. Fen

I guess what I am trying to do is" If Me!Text214 < 1.66 Then his happens: Me!minlang.Visible = True Me!Text150.Visible = False Me!Text218.Visible = False Else Me!minlang.Visible = False Me!Text150.Visible = True Me!Text218.Visible = True And if this is the case: If Me!OWNERINT = 1 Then...

Thanks Paul, so how should it go? Like this? Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer) If Me!Text214 < 1.66 Then Me!minlang.Visible = True Me!Text150.Visible = False Me!Text218.Visible = False Else Me!minlang.Visible = False Me!Text150.Visible = True...

Hi, I am trying to add another IF variable to a report. This way it works perfectly. Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer) If Me!Text214 < 1.66 Then Me!minlang.Visible = True Me!Text150.Visible = False Me!Text218.Visible = False...

Hi, Not sure where to put this one. I am trying to change the status from 2 to 1 for a option group control when a record is printed. Is there anyway I can do this with VB all the way, so on a button when pressed it: Prints the report for the record in view (already have this part)...

Hi, Is there anyway to have a duplicate DETAIL area on a report? I note that the report can have several Header and Footers but only one detail. I have a report that is grouped by name and can have say multiple listings of something. The name is the top header, and the detail shows the...

Thanks, that looks great. Where do I put that code? Thanks. Fen