Search results

Hi All, I need to change the format of a date in a unbound textbox. I want to change it from dd/mm/yy to dd.mm.yy, simply changing the / to . I used a input mask and set the format to dd.mm.yy but still returns the date has dd/mm/yy. Basically I am using the value from a calendar to open a...

Hi All, I know there are several different ways and editing/viewing excel data through access. I was wondering if anyone has a preference or best practice. I could use : DAO Link the worksheet etc etc Basically I want to view and edit the spreadsheet in an access form, rather than the user...

Hi All, I have a Continuous form which displays about 5 records at a time, due to multi-function forms that need to be displayed. Basically I want to hide the scroll bars and show 2 text links that say 'Next 5' and 'Prev 5' and to display an image to say end of recordset when reached the last...

Hi All, I'm very tired and this is probably stating the obvious but I want to assign a value if the time is between 6am and 2pm. What is the syntax in VBA? if time = >#06:00# or <#14:00# Then 'assign value here end if Not quite there. Anyone help, gone a bit rusty. Thanks Andy

Hi All, I have been running a program now for six months and all of a sudden when the data is imported from three excel spreadsheets I receive the error : Error 3349 - Numeric field overflow on a docmd.transferspreadsheet line of code in vba. I have narrowed it down to one spreadsheet and...

Hi All, It's been a while. I have created a system where I want to email a report to a third party in a particular format, basically in Snapshot format. The problem I have is that they don't have access to the format and I am trying for them for there IT to get it installed. Is there a way...

Hi All, I want to use the mousewheel to scroll through the list in a combo when the combo has focus. Can this be done? Any help is appreciated. Thanks Andy

Hi All, Just wondered if anyone has any experience of data being transmitted via EDI(electronic Data Interchange). I am wondering what sort of format it generally is transmitted in and it is something that is up and coming and I will need to amend the data import facility of my db if the format...

Hi All, Just a quick one! I have a combo ona form which is unbound, with a list of functions. When the user selects an entry from the list, as soon as the selection as been made I want to run the code from a module. Just don't know what event or if it is possible. I trying to do this without...

Hi All, I currently have a multiselect listbox which shows all Employees and there relevant department from tblEmployees. For Each Employee that is selected I want to add a record to log the time in and out to tblTime. But I want to look up the table tbltime to ensure they haven't already...

Hi Guys, Done a search of the forum on this, but some of the answers have not been concise or don't apply to my situation. Anyway, I want to import data into the db but how do I import into multiple related tables. FOr example: tblCustomer CustID CustName CustAddress tblOrders OrderID...

Hi All, Ok I run code to assign a field to fill a vehicle ("LoadNumber"), which assigns it by Site and ProductCube per vehicle. So now I have 4 products that will be placed on top of another 4 products(not likely to change). Currently the records will display as follows: Purchase Order...

Hi, Is it possible to pass form values for a range through to the transferspreadsheet command? for example current code: DoCmd.TransferSpreadsheet acImport, 8, "tblImportProducts", "c:\file.xls", False, "Sheet1!D3:D10" but change it to: DoCmd.TransferSpreadsheet acImport, 8...

Hi Guys, I have a table with about 12 fields and for each record not every field is completed with data. There is a possibility the structure might need to change. Basically I want to show only the populated fields on that particular record in the textbox in the following format...

Hi Guys, Is it possible to show the date and time which is refreshed every second in the status bar? I know this can be done in a form, just wondering if it is possible using the status bar. Done a search here and on MSKB but turned up nothing. Regards Andy

Assign Value to table based on recordset Hi All, I was wondering if anyone can help me in trying to write some vb code for the following purpose: I want to loop through records until a quantity of 21 is reached then assign a value to a field then carry on with the loop. If 21 can't be met...

Show No of Records in Report? Trying to count the number of records in report based on a query. Does anyone have the code to show the number of records in the query on the report. Many Thanks Andy

Calculations..How?? Hi all, I want to automatic allocate stock to vehicles based on a cubic measure, which is recorded in my products table How would I go about this ?? The vehicle would have a maximum cube and I want to press a button to allocate all the details from a temp table of all...

Hi All, I am looking for any suggestions/ideas you may have. What I am trying to do in my project is to automate building of vehicles by cubic measure. I was going to have in my products table the measure per individual product.(Cubic) Products Table ProductID - AutoNumber ProductCode -...

Hi, I am trying to generate a graph in access from a query. I can do this no problem, but I want to only show the last five days automatically. At the moment I have set the date range but once these dates expire the data in the graph will not show the last five days. Is there an expression...