matrekz42
Last Activity: May 8 '19, 04:14 PM
Joined: Sep 4 '07
Location:
-
thank you twinnyfo, I changed this in the meantime to keep working. I would ultimately like to get the SQLSafe working, but this definitely helped. -
Hi Neo, I created a module and entered the function. I then replaced the docmd.openform withCode:DoCmd.OpenForm "Inventions", , , "[Invention_Idea]=" & SQLSafe(Me.[Invention_Idea]) & " And [Design]='" & SQLSafe(Me.[Design]) & "'" & " And Invention_Desc = '" & SQLSafe(Me.Invention_Desc) & "'"
Leave a comment:
-
Hi Neo, good to hear from you. I still received the same error. The name has the following: customer's and hence the reason I get the error because of the '.Leave a comment:
-
OpenForm with single quote in criteria
Hello there! It's been a long time since I've reached out to the community for assistance, I thought I had this pretty much figured out! But, I've ran into a problem where I cant get the following to work, because in the Invention_Desc, one of the descriptions has a single quote in the string.
...Code:DoCmd.OpenForm "Inventions", , , "[Invention_Idea]=" & Me.[Invention_Idea] & " And [Design]='" & Me.[Design]
-
Help retrieving values from table row+column header
Good Afternoon,
I'm trying to query the following:
I have a table that has a row name and then a specific column name for that given row name.
I have a query that will return the following values as independent fields,...Code:(row) Rate Segment Segment2 1 56 5 2 90 12 3 100 15 4 25 45 5 13 2
-
Date Query
Good afternoon,
Maybe this is an easy task but I cant seem to figure it out. I want to create a query that will be linked to a list in a form, which has years ie: 2007,2008,etc.. .
I want to query a field that has 01/02/2007 but get everything that's in 2007 by only the year that the user selected in the form.
I know how to link it to the form ie:[Forms]![Report Form]![List27], but what formula or what... -
There is a lot of code for this in Google, also a lot of situations that are different for each user, and if you are literally going to be in front of the machine to hit the security messages, or if you want the code to do that for you.
Let me know and I can dig something up....Leave a comment:
-
Hi, if I understand your question correctly, in your query within the form in the "[ID]" criteria place: [Forms]![Form_Name]![Field_Name] . This will point back to the field you want from your form....Leave a comment:
-
Database Corruption
Good afternoon,
I have an MS Access DB, that I was working on and all of the sudden it just stopped working, I cannot compact and repair, I cannot import, I cannot use Modules, I cannot use the JetComp.exe , I cannot do anything, my main concern is I want to retrieve my VB code. What should I do?
Here's the error message I get: "Microsoft Access has detected corruption in this file. To try to repair the corruption,... -
OK, I figured it out. The problem was... Drum roll please...
The Mysysqueries would keep in memory that I saved as a form and was reseting every object's source back to what it was before
So I fixed it, but thanks for all your help.Leave a comment:
-
The Source of a combo keeps getting changed by itself ???
Good morning Guru's
I have a form that has a combo box and the source of a combo keeps getting changed by itself.
I haven't found the pattern if it happens after compact and repair or after debug. But the criteria of the source changes to sort by same item in another form.
The entry form is meant to sort by [form]![Entryform]![cbo_file] and it automatically changes to [form]![Auditorform]![cbo_file]... -
Hi Fish,
Thank you for your response, I tried those scenarios with no success, is there a way that I can change a value to one of the duplicate records for example:
I have a table with an account ID and there is a $ amount associated to that ID, but now I have two duplicate ID's with the same values but for different dates.
So I want to keep both but maybe change the value to the latest record, I dont...Leave a comment:
-
Deleting Duplicate records with different criterias?
Hello Guru's
(DELETE QUERY)
I have a table that has an account number field and a dollar amount associated with that field. I want to delete one of the fields only, if the dollar amount is the same, and keep the other account number field. How can I go about this, I've tried the following, but it deletes both and it's only for the account number...
In (SELECT [account#] FROM [Table1] As Tmp GROUP BY [account#]... -
OK, will do. Thanks!...Leave a comment:
-
How to make queries run faster in VB.
Good afternoon Gurus!
I don't know if this is possible, but I'm running code behind a button in a form that runs multiple queries, about (30). Is there a way to make these run faster? I'm using the following code:
stDocName = "Query_Name "
DoCmd.OpenQuery stDocName, acNormal, acEdit
Me![MyProgress].Value = 5
stDocName = "Query_Name "
... -
How to change the width of a TextBox in Acces form, when button clicked.
This may seem extremely simple, but I want to have in VB a code that will change the width of a TextBox when a button in the form is clicked. How can I go about this? -
No problem, thanks for the heads up though!...Leave a comment:
-
That's some good stuff, but it didn't work, I think it's because I dont have a subform in the tab I'm trying to get the info from the date picker.
So I have the form, and within the form I have (TABS) and in the first tab I have a subform but in the rest I just want to set up criterias to run different queries, using date ranges....Leave a comment:
-
Form in Access with Subforms/Tabs
Hello Gurus,
I currently have a form that houses multiple subforms and it's all on tabs, within the form.
I have a query that I want the date range to be called from a DatePickr that is in one of the tabs, but it doesn't recognize it. I tried the following:
Between [Forms]![Totals By Date]![Start] And [Forms]![Totals By Date]![End]
as the criteria for the date, but it didn't work because...
No activity results to display
Leave a comment: