Search results

Hello, i have a excel spreadsheet that has a column with a persons surname (comma) and firstname i.e Steve, Jones. I export this spreasheet in Access, but would like to splitt the surname and first into separate columns in the table.. whats the easiest way to do this?? Thanks

My new plug and play barcodescanner outputs a string of numbers and a Carriage return....tested with notepad and it works fine! I have got it set up to fill a textbox on my Access form, but im having to scan my barcodes in twice the before i get it to update records in my listbox. I have set...

re: Thankyou. Worked great

Hello, just need some help correcting the syntax with the below. Vend is the name of my input textbox on my form, but the value entered will not copy into my table 'Notsent' Can anyone spot why? Thanks. db.Execute " INSERT INTO Notsent " _ & "(Vendors) VALUES " _ & "('&Vend');"...

Hey all. I have 3 files on my c:\ drive work_040607.xls work_050607.xls work_060607.xls What i would like to do when my access app starts, i click a button on my form and all work_*.xls files from my directory that have a date greater or before the current date are deleted. So, if todays date...

Hello, Could someone advise me how to fix this little problem i have when importing a spreadsheet. My app outputs two columns into a spreadsheet with the following US date formats. The spreadsheet it generates is called dates.xls, and i need to re-arrange all the dates in the spreadsheet to a...

re: Gary thankyou, but if you dont mind, can you do me an example of a form with two textboxes only. The form will be dataentry only. Textbox1 named Product will write to Product in table1 Textbox2 named Type will write to Type in table2 Yes i will have more textboxes in my form, i just...

re: Gary, its not what i am trying to do. Let me explain When you create a form from a wizzard you can set its record source in properties, so i can have multiple text boxes on my form and it will write to the assigned table. i.e table1. However, in my instance, i have a textbox on the same...

re: i've created the table, and i've created the query. On the form, how to i assign my "product" textbox to write to query heading "Product" thanks

I have a textbox on my form and the forms record source is table1. I have a second textbox on the same form, but i would like to make its record source table2. What is the property i need to change to make it write to table2. Thankyou

hello, i would like to design a simple form that will show the date in say 7 weeks, if i enter 7 in a text box, if i enter 6 then it will show the date in 6 weeks time based on the current system date.. i understand this may need a calender function so any help appreciated! cheers!

Hi all, I have created a database for work in Access2003. I have two questions. The first is, many people at the work place use AC97 and some use AC2000. In order for everyone to use the database, i have saved it in AC97 format. It seems to open fine in Ver2000 and 2003, but i get this nag...

re: thanks chaps

Hi all, i have a form with a header that contains a few data entry txt boxes and a search button, with the body of the form returning the filtered results of my search criteria. Now i've had to set the form properties to Data entry to allow data to be entered, but it also allows the filtered...

Hi all, i have a form with a header that contains a few data entry txt boxes and a search button, with the body of the form returning the filtered results of my search criteria. Now i've had to set the form properties to Data entry to allow data to be entered, but it also allows the filtered...

re solved it! text box with default value set to Date(), called the txtbox "tdate" and called it up in the code.

hi, im using codecontextobject to write data directly into the record column in my table. I cant get it to write today's date into the record though? i've tried [Date] = date... any one know? thanks with CodeContextObject [Type] = x + 100 [Date] = ?? end with

Hi mate, Null did not work and using "Both" did not work either. How does opta know that it needs to return RECEIPTS and REJECTS in the above format? The quickest solution (after i thought about it) was to create a new query and report for "BOTH" and it works fine now :) The 2501 trap code...

hi all, in code, how to do i make a report close automatically if it detects no records are contained within it. The report is generated from a query. thanks

re: Neither of the above work my friend, even though i understand your logic.. its weird..!