Search results

I'm with plog. Unless there is a reason to have 2 BE's. Don't just do it because there are two FE's. Easier maintenance. Don't need to compare and update or sync data from 2 BE's.

your code is in a separate module instead of being behind the form. Go into design view on your form and the event property for on current. Go into Code Builder, then copy all of your code there and delete it from your module.

post the sql for your query and the name of your combobox. you just need to reference the combobox in your query where you have the parameter.

what happens if you do this? nFldType = dbText nFldSize = 20 I can't see how you defined your fields, but the field size should be an integer, not a string, so I removed the quotes.

The easier way to make your Serial field to be required is to set it in the table design. Or to set the Validation Rule & Text in table design.

Do the other Access databases create Excel objects? See if you can do a repair of Office before a reinstall. I also like the suggestion of creating the Excel object in Excel or Word to see what happens.

I'm trying to do what you're doing, but not getting the same prompts. Are you trying to get Access data into Excel, or Excel data into Access? The prompts you're getting sound like you're in Access, but why are you then choosing "From Access" instead of "From Excel"? Also why are you exporting...

How is xlApp defined? what happens if you enter 'CreateObject ("Excel.Application")' into the immediate window? Is there any difference between versions of Office with this computer?

move your 'end with' before your 'end if'

I have comboboxes that are alphabetized and I can start typing and it'll jump to the first record which matches. It doesn't eliminate to only those letters, like you're asking. But this is close. Is it close enough for you? This is the way it works without doing anything.

I'm assuming that the order ID must have data in the field when you click the clear button. 1. If the orderID was blank this could be checked in the lost focus event and ignore the lost focus. 2. Or maybe clearing the ID and tabing out would cause call the clear button routine. 3. Maybe you...

Also it's possible that the tables are ok, but your query needs fixed. Can you post the SQL or a pic of the query (in addition to what plog asked for)?

looks like mine except I don't allow multiselect. You could remove this and see if it works also try stop the code in the debugger at .attachments.add and look at the selected items to see if it looks right

I'm not proficient at pivot charts, but to get data into Excel - Open the table/query you want to export data from>External Data tab>Export group>Excel and walk through the wizard. If you have fields you don't want exported, create a query with only the fields and data you want in Excel. If this...

ellen, so your back end is hosted by someone else? then the wait timeout would be the amount of time from them receiving an instruction from your front end (the code/forms/etc) for them to process the response before they give up. In other words if you do a query of the data which takes over 60...

right click your join line between workorders and sum of payments and change to left join. then try again.

Screenshots helpful? Always

You say you're not overusing it but apparently your tech support people think you are. I don't know how to stay connected when your networking people are booting you off by the settings they have. Maybe you could trap the error that occurs and reconnect? Sounds like the user will get frustrated...

Not to the best of my knowledge. Microsoft used to have a utility that would search through everything (including queries) for something you typed in. I think it was in the developers kit. But it was for Access 2003 and I don't think it made it to the newer versions. You could select where you...

Trying to figure out what you mean. Are you asking how to reference the textbox in your query? strSql="select..." & me.txtbox & "more sql" or maybe you mean strSql="select..." & stringVar & "more sql" I hope one of these is correct, if not try reexplaining and give an example.