Search results

Hi So i have all dates fields set as text fields within Acess, so its format is like yyyy-mm-dd-hh-mm.000000 etc. I can use Left(date,10) to get YYYY-MM-DD, i can live with this rather than DD-MM-YYY. MY issue now is i need to be able to add a number (leadtime) to this date, but it doesnt...

Hi The mouse wheel scrolling between records no longer works on my forms since switching to access 2007. I found this link which should resolve it if i add code to a module etc (link) http://allenbrowne.com/ser-70.html The trouble is i cannot do step 4 as when i goto "properties" and...

I have created a table for supplier production and i have set up an append query which updates this table from an imported excel sheet with all the data. This works fine the first week. My trouble is when i get the new data from suppliers the next week and import into access again, and then...

Hi I have set up an append query, but it is duplicating every record in the file, rather than just updating the fields that have changed. If i hav an "order num" as a primary key in the table, it appears to work, but then i cannot run my update query as it wont allow duplicate order nums...

I have created a form which after i enter the order number, it shows me details. These details are just for show. But I have 1 field which i need to be able to update, how can i do this? just dragging the field onto the form doesnt allow me to enter anything in it. The form is linked to my...

I have created a form which after i enter the order number, it shows me details. These details are just for show. But I have 1 field which i need to be able to update, how can i do this? just dragging the field onto the form doesnt allow me to enter anything in it. The form is linked to my...

I have created a form which after i enter the order number, it shows me details. These details are just for show. But I have 1 field which i need to be able to update, how can i do this? just dragging the field onto the form doesnt allow me to enter anything in it. The form is linked to my...

Hi. To cut a long story short, i gather excel sheets from various suppliers, bang them into 1 excel sheet and import this in access and use an append query so it updates into a table. my problem is when i run do the same the next week as i do on a weekly basis, if the suppliers change data...

Hi. I need to be able to export my "form" into a pdf format, or something similar. Excel just lays the data into 1 row and does not include the ole object(pic) or subform data. I need to keep the forms design/format and ole object and subform data. (so it looks like is does in access) (like...

Hi I have created a Form in Access which acts as Front Menu with buttons on, 1 of these buttons opens up another form which is purely used to "view" details, no adding, updating, etc. These details come from an excel spreadsheet which i have linked as a table in Access. The trouble is...

Hi. I want to open a report using my form, this is easy enough, but i cant figure out how i get the report to show details for the selected order number on my form. At present i have the queries which run the form and report set up so you have to enter the order number. This is fine for the...

I am looking into using some historic prices/rates to calculate values. The trouble is if the rates/prices change, the values will automatically be calculated on the new prices, Is there anyway i can use for example a rate from 2008?? Is not not an option to have a seperate database table for...

I created a query to display data from multiple tables, then created a form using this query. You enter a product code and the details are brought up. 1 of these fields in the query is "comments" I want to be able to update the "comments" field from the form, I can click in the field but i...

1. create an excel sheet with just the weeknum formula in it, then save it. 2. create a form in access and add a command button to open the above report. 3. Does the weeknum display when the excel sheet is opened from your form button ?, or is it like mine and just displays #name? in the...

I Have a excel spreadsheet that uses weeknum formula, this works fine (in excel), but i have created a form which when you click on a command button, it opens this excel report, but for some reason weeknum does not work, only get the #name? value, I know you cannot use weeknum in an access...

I have created a form, a menu if you like. I have a command button set to open a specific excel spreadsheet that was origianlly created in excel, so it uses formulas such as "weeknum". When i click on the button to open this on my access form, i get #name? instead of the weeknum. Is there...