Search results for query: *

Can you pass a recordset between forms and functions. I've always used user defined types. I have one routine that handles everything from all forms/functions etc.

I have a user defined type there are 50 fields in it. I am writing a piece of code which will use an array of field names to access the fields in the user defined type. I am using the userdefined type to pass a record from a recordset between various functions, the screen and a recordset. I...

I am writing some code where I want to reference a user defined type via a fieldname which is held in a variable. Does anyone know how to do this i.e. Type TestType desc as string code as string End Type Dim FldName as String Dim AUDT as TestType FldName = "desc" [AUDT.FldName] =...

I can create a chart using code no problem, bar charts etc. I can create a combination chart using a bar chart and line chart however when I set the second data set to be a scatter graph, it takes over the chart and the whole thing becomes a scatter graph as opposed to a bar chart with a line...

HI I've developed a system that produces automated bar charts based on the frequency of something i.e. density/weight etc and emails them to me. However I want to add a minimum and maximum line to the chart so I can see which bars are with the minimum and maximum ranges. Can you do this if so...

Hi I've got the keyword "Format" in there it appears something to do with a reference Microsoft ActiveX Data Objects 2.8 If I open the ADP on the machine the database is fine, If I open the ade id does not work. To fix it I simply opened the ADP. Removed the reference and then added in again...

I have a database (ADE) that works ok on my PC. This database was developed on my machine and turned into an ade on my machine. When I go to another PC on all my date references it comes up with #name?. If I load up the adp the date references are fine. I can then create a new ade on that...

I developed an application in access (My First One) as an ADP. Using the information in here I have managed to create an ADE file (Had compile errors and wrong file format). My application runs in a small centered window but when I run the ADE access launches itself fullscreen with my small...

Hi I am trying produce a stacked bar graph but I want the bars across the x axis to also be to scale. i.e. If bar one has a value of 100 and bar 2 has a value of 50 I want to display the first bar as twice the width of the second bar. Anyone got any idea ho to do this. Thanks

do iif's not work in adp's then? Is there a list anywhere that tells me the difference between mdp and adp because a lot of the things I use to do with mdp's I can't do with adp's I got around it by changing the input form so that when any numeric is set to 0 then that field is not wrote to...

I have got a break on product description so its in there its the d3desc footer I have a control in the detail line and the code runs with this value entered, but I cannot sum a control source. IIf([d3force]=0,1,0) I have entered the value below in the break footer and it causes an error...

I have a problem with a report where I am trying to count the detail records in a report but exclude both null and zero values. I have looked through the forums and found a couple of answers but they do not work for me. I am using a ADP project and using MSDE (Free SQL) as the backend. If I...

I am using access 2002 to create an.adp project. I have a number of tables which I have imported from an old mde database that someone developed. In this database there are two fields d3cdate (ShortDate Format) and d3ctime (Medium Time Format) The database is held on an MSDE server (Latest...

I have created an access 2002 project (.ADP) with a series of tables stored within MSDE. I want to create an enquiry form where I can enter some data (ie. date from, to) into fields on the form and have the data appear in the subform below. I would then like to use this data in a report. I...

I've wrote some code to extract some data from lotus notes into access using odbc but I have a problem with the field types. If I use the code Let texttest = rstnot![NorD] This will set my text field to the correct value from the notes recordset field. BUT === In some cases you cannot use...