Search results

Hi all. I am using vba to upload files to an ftp server. After some tweaking and trail and error I have it working correctly except for one part. I am not sure how to make it find if the directory exist or not. Open "G:\script.ftp" For Output As #1 Print #1...

Hi all. Still being a VBA newbie, I can fudge myself through most things but a little stuck on this one. I am using code I found that uses outlook to send emails. I can get it to attach one file but I need it to be able to attach several that the user selects. I think I need an array to go...

I am trying to display a message box with variables from a record that is found using a query in vba. I can get the correct number of msg boxes to display but it only shows the value from the first record. Can someone tell me what I am doing wrong? Please and thank you Dim strSQL As String Dim...

New to web forms and having an issue with a combobox. I finally got it so I could select a record to display in the form but since I have 5777 records and the combobox will only show so many I need to find a way to dispaly them all. The one I am making this for does not want to type in a company...

Playing around with Sharepoint and Access. Does anyone know why I can not change the option for the web display form in the options of the current database? Thanks, -Matt

Not sure if I am posting this in the right place, sorry if it's not. I am stuck. Not real familiar with mysql or php but can fiddle my way around. I am trying to set up a script that will get email addresses from the database and insert it to the script and email the addresses it gets. I have...

Hi all, I am trying to figure out how to insert a number based a few things. I'll get right down to it. This is what I have. Column A Column B Column C Description Amount Date entered I need to find the latest date where column A = "house" then I need to see if it is greater...

Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get...

Hi all. Using Access 2003 I am trying to figure out how to print and collate a report and an existing pdf file that is opened based on a field in the record. I figure that it probably has to do with looping through the records but I am not very good at that. So I have a form with a sub form...

Need help getting this.. Need to check the value of a barcode in a text box to see what the first character is. Like this; If the first character in txtScannedBarcode is "M" then I want it to open frmM If it is a "B" then I want it to open frmB and so on. The values would be along the likes...

Ok, I hope I can explain this so everyone can understand what I need. I know all the relationship stuff, linking and tying the records together. I need a way to keep track of parts that go into machines, these parts can be changed frequently and interchanged from machine to machine, and I need...

I hope you can understand this: I am looking at making a form to show around 10 small charts. I would like to somehow have a query or something that would get all the unique sample names in a table and make that many charts (each sample name having its own chart). So lets say when someone opens...

I have searched high and low and only able to come up with answers pertaining to excel. I would like to know if there is a way to control different properties of a chart from VBA such as the scale of the axis. Thanks, Matthew

I am trying to use DLookup to get a value from a previous record on a form. The value I need is in an unbound textbox that performs a calculation. I have discovered that the DLookup doesn't work correctly with an unbound control. That wouldn't be a problem as I could just do the calculation in...

Is there a way to turn off the right click so I can have it show something else instead of showing the context specific menu. It does show what I want it to, but I don't like have the menu come up with it.

I hope I can explain this and make any sense. I am trying to make a form where I can choose in a query what fields I want displayed. I have a combobox that I choose the table, and another combobox that list the fields that are available to view. So I get: tblZincWastewater.Analyst...

I need to get the most recent data from a coulmn that is not null. The table is dbo_SouthVariable1 and the coulmn is AIM_N7089 and the date column is Rec_Date. I tried using DMax but not getting it to work for me. I hope you can understand this, I'm not very good at explaining what I mean. :(...

I need to make a report that shows everyday of the month. My problem is that I do not have data everyday. Is there a way to list all the days of the month and fill in the data on the days that there is data for? Hope you can understand what I need. Thanks, Matthew

I am trying to make a query for a chart that includes the following fields from a table tblMetals: AnalysisDate AnalysisName SampleName ReptSmpmg ReptBkgmg I need to do some calculations for the chart as follows: Result= ([ReptSmpmg]-[ReptBkgmg])*100/1 Average= Avg(Result) Std= StDev(Result)...

I have a form that is populated via an append query with 28 new records that have different sample names entered into the SampleName field. I need to have "-----" entered in to some of the fields depending on what the sample name is. I would like this done automaticlly when the form is opened...