Search results for query: *

hi i am trying unsuccessfully to export a query automatically via a button to excel using the below code but i keep getting errors. can anyone see where i am going wrong? very frustrated. thanks query is called exportexcel spreadsheet is SendCarRequestExcel and the sheet name is also...

Hi i would like to put on a button an automation for exporting a queries data into a specific excel spreadsheet. i only know the code for importing below DoCmd.TransferDatabase acImport, "Microsoft Access", _ "h:\pcs.mdb", acTable, "Table1", "test", False many thanks Energy &...

Hi i have programed in that whoever the user is for the machine is tracked in a field on the form. so if joe smith is logged on a field says joe smith. should someone log into the form that is not within the registered user table of course it appears as #error. what i need to do is put an on...

hi is it possible to take a name like jim smith and break it into 2 field first name and last name? Energy & persistance conquer all things!

Hi i am having a problem running a query that compares last months data to this months data. the tables are the same i just want to see if changes have been applied in the new months data. i am running a query extracting the information using a cardno field that is in both of the tables, but...

Hi i have to refer to a client name from another form and the problem i am having is the name on the refered form is John Smith, however the information for the next form i want to bring up has 2 john smiths but one has a middle initial in it, so only one record is being brought up not the two...

i am trying to create a multi select list box using the below code. i am storing the occupant into a table for use later in reporting, however i keep getting the following error message "Error No 3075 description syntax error (missing operator) in query expression 'occupant = 1 car bay' can...

hi i have just converted to 2007 and when i am applying the code below to the on print event in the detail section it is no longer working. i am trying to alternate line row shading. can anyone assist me with why this isnt working? Is it done another way in 2007> greatly appreciate any help...

Hi i am using access 2007 and would like to know if i can open an excel spreadsheet via a button on a form. if anyone can help me i would greatly appreciate it. Energy & persistance conquer all things!

hi i have recently converted to 2007 and am trying to get into start up functions that i used to program a form to open when the user opens the system. does anyone know where this function now lies/ i can not locate it in any of my helps thanks Energy & persistance conquer all things!

i would like to know if it is possible when viewing a continuous form can you get rid of the blank record that appears on the bottom of the page? if there is only one record for a person having that blank record on the bottom can be confusing. can i turn it off? thanks Energy & persistance...

Hi i have created a form where i use a combo box to look up a name and then it populates other fields via the code [Forms]![FrmNewApplication]![CboRCN].[Column](1) my issue is probably basic but i am stuck nevertheless. when i click on the save button any new fields populated by these...

i am trying to import a database table (via macro) so it is automatically done from a table in another database. i keep entering the correct path and it is not doing it. it keeps refering that it can not find the file in such and such, however the directory it is quoting me is not what i...

i want to delete a errors table that i get upon importation of data. this will be a regular occurance so i want to delete it each month after the user has imported their table otherwise they will just build up of tables. i have the below code but does not seem to be working. any ideas would be...

hi i am trying and have been for awhile to create a multiselect list box that saves my selected data into a table so i can use that data later. Fields are simple CostID, RCN,and department name. seems simple but just can not get it. thanks Energy & persistance conquer all things!

i have added a pop up calendar for users to use and for some reason when i query the dates selected by the calendar it does not seem to register the date values. i have queried the same data and manually typed in the dates and then it works. the referenced text boxes are formated to date. i...

hi guys i have a question, i have actually done it and i can not for the life of me figure out how i did it a long time ago. i have a form where i want to view the relating email in a record. i have one working now as i said i just can not remember how i inserted the email into the table. i did...

hi guys another strange problem i am using the below datepart refernce to obtain only the year from a date field and the date is 31/01/08 and for some reason the code is picking up 1905. can anyone tell me why? Energy & persistance conquer all things!

hi another question i am having difficulty with. i have a form with a tab control of 3 pages, how do i refer to a field on that tab? i want to automatically get the 2nd colum data from a cbo box. usually i would use the below code but it doesn't work. i know i need to refer to the page # and...

hi i have a continued question from my previous post but as it's a bit different i thought i'd start a different thread. i basically want to requery the cbo box each time someone clicks on the down arrow so they get the latest data. the cbo box is made up of 2 queries below that are run when...