Search results

Thanks CJ_London that was exactly what I needed. I had switched tasks during my internship and when I came back to Access I was sort of struggling to get up and going.

Hey y'all, I have a question and I'm having trouble putting into words what I'm trying to do so I couldn't really search the posts. If this has already been asked and solved please just direct me there. Thanks. There may be a better way of doing this, but I have a Log table where I make an...

The textbox that had LAST NAME as the control source and the textbox that had FIRST NAME as the control source stopped being populated. They were simply blank when the report was opened up. I used the report wizard to make the report. The report, of course, is populated with information...

HAHA thank you. I fixed that. I got the right data in my report, BUT now I lost the first and last name that would go into the report. I made a change because I had NULL instead of ASSIGNED to as the last field on the second select statement. For completeness here it is. I copied it from the...

Ok so my report is 48 pages when it should only have about 5 entries I'm not sure why but here is the code I implemented. Private Sub reportBtn_Click() Dim rptStr As String rptStr = "'" & Me.ReportPersonnelCombo & "'" If Len(ReportPersonnelCombo.Value & vbNullString) > 0 Then...

Forgive me, but I don't understand why that is important. The query where the parameter is defined works.

When I click ReportBtn Access still wants me to input a value for the parameter 't_asset_master.ASSIGNED_TO' even though there is a value in Me.ReportPersonnelCombo The code for the button click is this Private Sub ReportBtn_Click() 'MsgBox ("This feature is not complete yet sorry")...

Hey yall this looks like something I'm trying to do to but it is with a union query and a report. The "where" clause is the same criteria for both select statements in the union. How would I send that in the as part of the Open Report command? Or how else should I handle it?

This ended up being what I needed I just apparently had some mental blocks. This snippet returns the "WHERE" clause of a SQL string but does not contain the word where. This was done be able to open a datasheet form with a where statement. Dim intPos As Integer Dim strSQL, tempString...

This may seems to be what Im looking for but this is VB without the A haha BaseQueryFormStr = RSet(strSQL, len(strSQL)-intPos)

I think I have another issue. Example: Say strSQL="SELECT last_name, first_name FROM people WHERE id=7" Im trying to get BaseQueryFormStr = "id=7" I want everything from the right of "WHERE" The code, as it is, I don't believe will perform as I want it too. I thought...

Yes I believe the runtime error was because I was trying to cut the string at index -1 i.e. intPos which was zero minus 1 strSQL is defined as a string data type BTW just neglected to put it in the code snippet. Thanks for the kind words and advice MSAccessRookie

:banghead: If I don't make any selections on the form where query is being built there is no where clause to add because I want all of the results. Having the full string come out in the message box showed me that. Maybe its time to take a short break. :D

Hi People who make my life easier :D, I had trouble deciding where to post this thread so I apologize if it is misplaced. I want to that the WHERE clause for a SQL statement that I am using options on a form to build. I intend to use the clause in opening a datasheet form. This is the code I...

That was helpful for me JHB I hope it works for kloot1rr

I may be misunderstanding what you asking to do kloot1rr. Would a RIGHT JOIN (all the rows from one table and only the rows from another table that are joined ON a field where they are equal) be appropriate for what you are trying to do? If that works you could you the Query Designer to set...

You're right PBaldy I guess since I'm pulling that same fields with the same number then I properties setting took care of it. Is there a way to set the field width from within the code say if I wanted the listbox to have 4 fields and only show three? For completeness this is my working...

I'm not sure that helps with my particular issue. This is a code snippet I have in City_After_Update() that drive the listbox for the Locations. When you select a city or multiple cities the Locations listbox is populated with locations within those Cities. Set CityListCtl1 =...

Hi, I am building a form that uses list box selections on the form to make a temporary query and open the results in Excel. It mostly works in just trying to make it more functional. Currently the listbox that contains the first and last names of the personnel also has a unique shorttext...

I did some tweaking got it to work and yes I'm I will be able to transfer this over to my other list box. I WHERE IN did need to be changed duh! me :banghead: I'm not sure why the solution I was working on a week ago didn't work Access seems to like being restarted every now and then...