Search results for query: *

Ok so I am trying to open a form with another form and have it pull the record that corresponds to the date selected on the first form. I am trying to use the following, but it is just opening a blank/new record on the form. Private Sub cmdOpen_Click() DoCmd.OpenForm "fData", , ...

So I have a combobox on a form with 2 columns in it. The report needs to get the data that is currently selected and in column 2 of that box. This is what I am using for my control source for the text box in my report, but it doesn't work. I imagine I just have this formatted wrong...

I wasn't entirely sure where to put this post, but here goes anyway. I have 2 text boxes on this form, on top of each other. What I am doing, is displaying one text box which has a time in it, but when it gets focus, it moves the focus to the other box which has the time in seconds. The time...

Ok, well I am not sure this is the best way to get this done, but here goes. I have a database which lets users select items from a list on the left which will be added to the list on the right. When the forms opens it loads their preferences from the table based on their windows login name...

Ok, so I have a table with the following columns: UserName, ProgramName, OrderInList What I am trying to do is setup some code to update the "OrderInList" field, everytime a row is deleted. Here is how I am adding the data to the table... DoCmd.SetWarnings False DoCmd.RunSQL "INSERT...

What the heck am I doing wrong here? strAlias is a global variable set on load. I am getting "Run-time error '3464': Data type mismatch in criteria expression." DoCmd.RunSQL "DELETE * FROM tData WHERE sName = '" & strUserName & "' AND iRow = '" & lstStart.ListIndex + 1 & "';" Dan

What the heck am I doing wrong here? Probably everything, but hey... Basically I am trying to get the query to sort by the value of txtLocation if the value of it is anything besides 0. SELECT CASE WHEN ([Forms]![fReporting]![txtLocation]=0) THEN tData.sName, tData.sLocation FROM tData WHERE...

Ok, so I have an audit trail setup in my form, it is working fine, unless I change my rep dropdown to choose another user. Then it records the new user, instead of the one that was changed. I am sure this is a simple fix but I am drawing a blank! I am thinking I need to change 'sName' which...

Hopefully this will make sense on a Friday, but here goes. I have a database with a bunch of data housed as yes/no fields and checkboxes in the forms. I am wanting to create a report that basically lists out everything that has been checked as 'yes' for a each rep. I have my query setup to...

Ok, so I have been asked to find which value is higher in a column of times in excel. Currently I am using the following... [code] If Range("Z24").Value > Range("Z25").Value Then strDIUnd = Range("Z24").Text & " @ " & Range("X24").Text & "-" & Range("Y24").Text & " MT" Else...

Ok, it's been a while since I messed with Access, but what I am trying to do is update a form to pull a record up, after a dropdown is changed. I have 3 fields on my form, Name, Supervisor, Skills. There is also a subform with detailed data. I changed the name box to a combo box and it seems...

Ok so I am working on a spreadsheet that has a series of data broken up by quarter. I used this formula to sort it, there are 4 columns similar to this: =IF($F2<>"",CHOOSE(MATCH(MONTH($F2),{1,4,7,10}),$B2,"","",""),"") There is also another 4 columns sorting another set of data in the same...

Ok folks, I am not really sure where to go with this, all my VBA has so far been confined to manipulating one document. I have been asked to make a report from 40 CSV files and compile them into one Excel doc. I only need a couple values out of each file. Here is my code so far, I have been...

Ok, so I have this report that I can generate a csv file with the info I need in it, now I need to run the same report for several other split skills and append to the csv file. Anyone have any idea how to do this? Here is my current code, it is an auto script with a popup for the date I want...

I am sure I am just forgetting something from back in school here, but I am trying to figure out how to open another VB file and pass variables. I have the VB file setup to accept the input: Public Sub Main(strInput as String) The VBA calling the file is in MS Project, in case it matters...

Ok, so what I am needing to do is send this email from Project. It is working fine, however I have a request to carbon copy the supervisors of the users who are being emailed. I am really at a loss as to how to do this... any ideas would be appreciated! I am getting the users out of a cell in...

Ok, I may be losing my mind here, I know you can attach a toolbar in excel and email it to someone else so they can use it, but I am not seeing a way to do this in project. Am I completly crazy? Dan

Hello all, this is a somewhat off the wall question, and this may not be the right forum to ask in, but here goes. I am looking to add a toolbar to XP workstations with a batch file. Basically we have a bunch of links on a network drive. We want to create a toolbar linking to this. Not sure...

Ok, I thought I had this code working, but apparently not. I get unable to set series class of whatever variable I am trying to set with everything after I add the 2 NewSeries. Any help would be great! Dim strValue1 As String, strValue2 As String, strTitle As String, strYaxis As String...

I am trying to hide a complete row if the cell in column A is blank for a given range. Reports is the name of the sheet I am working with. This code seems to run very slow, any idea how to speed it up? This is what I am working with: Dim r As Integer For r = 6 To 36...