Search results

It's an annoying, random occurrence, which has no apparent cause. I have a search tool which opens when the application begins. It begins with an Open event: Private Sub Form_Open(Cancel As Integer) Me.SearchBox.Value = Me.SearchBox.ItemData(1) Me.Requery End Sub Followed...

I do not want to change the server, as I also use it for WP, which apparently prefers Linux to run... I would also prefer to avoid an extra subscription to a windows server to run it. the windows version of the server runs through ASP.NET, to connect to access via OCDB. Currently, all my...

My server provider is telling me that my server is Linux and I would have to upgrade to windows to be able to connect my database to the SQL... so i figured, if there was a middle man who could collect the information and pass it along? Is there an add on of sorts to allow access to behave...

I'm ready to upload my access database to an online SQL server. My current web server doesn't have open SQL abilities, so I'll have to subscribe to another service. I have no idea what I'm looking for or what price range is right? Any advice would be useful.:confused:

Google, for once, is useless... I am trying to create a sort of "interrupt" mode, where staff have log in sessions... Say, for example, a person logs in (e.g. they enter "Staff ID: 1") then start filling out a form, but someone else needs to enter another form, press "Staff Login", then enter...

I've done it! It may be the long way around, and I'm sure there may be an SQL that can do it in one... but heres what I did: 1) Make a query to find the duplicates, set by [Address 1], I called it tblAddDup, - apparently Access works faster by first making a count query and using that to list...

If the client can manage many programs, then that calls for a one - many relationship. Clearly Programs should be linked to the client through Client ID... Instead of [progID1][ProgID2][ProgID3] there should only be 1 progID. I still can't see clearly what's happening... but what I learned in...

Thanks pat, but the data would be exactly identical as the data has existed on 3 databases. My usual method would be to type the ID's of the other 2 records into the blank columns, then delete the other 2 leaving one behind. I should have mentioned I have around 14,000 address to compress...

Is there a way to do, for example; IF [Company Name] = Duplicate and Duplicate-Count = 3, then if ID-A Is Null then (take ID where ID-A Is Not Null), If ID-B is Null then (take ID where ID-B is not null) , IF ID-C is Null then (take ID where ID-C is Not null) Then Delete 2 of the duplicates...

you need to remove all repeated headings in excel... only have one at the top. Also avoid merged cells, it makes it less messy when importing. The grey cells needn't be greyed out for importing purposes. Things like DATES shouldn't be 3 separate fields. tblPerson [ID] [First Name] [Last Name]...

Thanks Pat, it's stage 2 I'm stuck with in your method. But it mostly makes sense. And Plog, that is a good idea, but the customer ID is used in another table. I can only convert and update the Customer ID to a single one when I've done, what Pat describes in step 2... hmmm

instead of %, use the decimal version. 0% = 0... 22% = 0.22 15 x 0 = 0... I have the VAT on a stand alone table and only reference it. It's not linked to anything. I do this because previous invoices have old VATs so i reference them to date. Then another query I link the VAT table in and say...

Alas, we finally have a way to share a central database, but I'm now left with a laborious task of merging the currently 3 separate databases. Combining them isn't a problem, but what I need is a short cut to match the ID's and merge the records into 1. For example, my table for address has a...

I was told once upon a time, it's worth learning SQL to replace queries as queries bulk out the frontend. So to increase efficiency and reduce memory I thought to convert all my queries in my databases into SQL... so row sources become SQLs, my append queries become INSERT INTO commands, and so...

It needs to be duplicated to be edited. It is to be used as a repeat order button, or as a "similar product" item, In this example, another customer may buy mounted boards, but they may buy 3 instead of 5, or they may be A1 instead of A2 size, but saves retyping all that information

No, unfortunately, it isn't a lookup table. It contains yet more variables. heres an example: [tblInvoice]: invoiceNumber: "0001", TotalDue: "£50" -[tblOrder]: QTY: "5", Description: "Mounted Boards", Price: "£45" ---[tblDescription]: Size:"A2", Stock:"Glossy sticker", Colour: "4"...

I found this incredible step by step into duplicating data: http://allenbrowne.com/ser-57.html I am using it for invoice purposes, a product may be similar to a previous one that was already entered into the system. We have so many products, with so many variables, this will be a useful tool...

There are 3 separate, geographical locations that need to share 1 back end database I think I've exhausted all options, other than buying an SQL database on a server that allows to share with applications. There is also paranoia about data security and protection from hackers. The only way I...

I am creating a step by step wizard, which means transferring variables to another form, one issue I have is if the wizard takes a step back... I need a snippet of code to tell the form where to get the variable from. Here's what I have (that doesn't work) - What this is supposed to do is...

thanks for all the replies guys! Every little helps... I think perhaps I used the wrong terminology - supposedly you issue a proforma to give credit and until it is paid it becomes an invoice - a receipt as it were. My company use duplicate pads at the moment, so they're called invoices in...