Search results

Hi Guys, I didn't know where to post this, but i figured some VBA would be needed somewhere. Okay so; I have a table 'PARTS', below is a small example: PARTS PART MODEL A MODEL B X 5 6 Y 6 7 Z...

Hi MStef, thanks for the reply Unfortunately the database wont run, most likely because i am running access 97, which i think is incompatible.

Thanks Apr Pillai, However this hasn't helped my issue with my original issue of incorrectly typed expression error. I have done some trial and error and found that the issues is with the query expression: Between (DateAdd("m",([Forms]![Repairs Recent]![text16]),Date())) And Date() Is there...

Hi, I have a form which has a number of text boxes that need their value multiplied by their corresponding value in a query. The query has a product field, and a product count field. Example: Text1 has a label called wood1 (the product), so i need text1 to lookup wood1 in the query (product...

Hi guys, Ive been getting that error (thread heading) when trying to run a query The query runs when i open a form, is there anything wrong with these expressions? Date Rcvd Field Between (DateAdd("m",([Forms]![Repairs Recent]![text16]),Date())) And Date() Product Type Field [Forms]![Repairs...

Thanks missinglinq, The option thing works fine for the moment, but i may need to use your code later if people start complaining that the other text boxes are no longer auto-highlighting... maybe they wont notice, haha.

Tried your solution RainLover (looked like the least work :P), works great!, no issues at all... yet :P Thanks to everyone else too.

Hi, I have a text box with a memo control source, when you click the text box an acCmdZoomBox is run. However when the Zoom box opens it highlights all of the data, which is causing issues with people accidentally deleting all the information. I have seen something about a selstart, sellength...

Hi, As you can see in the thread heading, i have an issue where i am trying to change a text field into a memo field, but i get the error "There isn't enough disk space or memory", so i changed the MaxLocksPerFile in the registry by following this http://support.microsoft.com/kb/209940 However...

Just wondering what computer software savvy people think about Energy sources, now and in the future. Whats your prediction? What would you like to see?

Hi, I have a combobox where its record source is from 'table 1' (the form's control source), however its row source is from 'table 2'. I then have a number of text boxes which also have 'table 1' as their record source. What i need is that when i select a value in the combobox, that the...

Aye, didn't mean to brand it as my own idea/solution, Bob was thanked. ...Thanks Bob

Hi guys, thanks for the help. The issue i thinkwas that i didn't know that the '#' characters were entered automatically... so i had it in the text boxes (ie literal string), so now i just simply have the date in the text boxes and 'Between [textX] and [textY]' and it now works fine. vbaInet...

No i meant 'it uses existing records', sorry. This is the SQL: SELECT DateSerial(Year([REPAIRS].[REPAIR_DATE_SHIPPED]),Month([REPAIRS].[REPAIR_DATE_SHIPPED]),1) AS Month, Count([1500].[SERIAL NO]) AS [CountOfSERIAL NO] FROM 1500 INNER JOIN REPAIRS ON [1500].[SERIAL NO] = REPAIRS.[SERIAL NO]...

I understand, but i really can't change the design of these main tables. For reasons: Too much data, too many other databases linked to the table, not sure i would be authorized to spend days changing the database... as we are updating our whole database in around 5-6 months, with professional...

Its working on existing records

Hi, I have a query which has 3 'where' fields, a 'group by' field and a 'count' field. The 'where' fields each have a criteria that refer to a form ([Forms]![Forecast_Update]![text17]), on the form is a button that runs the query (once the text boxes are filled), the query however shows up...

Hi guys, Thought I'd try this again, in a different forum topic. For reference an inverter is an electronic device used in solar systems. First... I have a form (PARTS FORM) with a combo box (PART) and a bunch of text boxes for each type of Inverter. When a part is selected, each inverter...

Hi, Ill be a using a cheese store chain as an example. First... I have a form (Cheese stock) with a combobox (Stores) and a bunch of text boxes (Types of cheese). When a store is selected, each type of cheese shows its stock for that store... I understand there is better/other ways to display...

Hi, I have a form which has a serial number text box. There is also a button that opens a search for that text box: Me.txtSerialNumber.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70However i have an after update procedure: Private Sub txtSerialNumber_AfterUpdate() If...