Search results

Hi out there, i have a problem. I want to block or hide just the default Access exit button (z in the upper corner) because some users use that one before logging out and that causes damange to the DB and it needed to be repaierd, but therefore everybody needs to log off.. so any idea how i...

Hi, i have an ecxel sheet witch contains 2 collums with dates. In Ecxel all dates look good, but when i try to import it to access (via the build in funktion "get external data" ) some of the dates change to numbers. Any one an idea how i could solve that? thanks:D

how to set focus on hidden textbox Hi, i habe a form where i have a tb that checks if record is changed. It works fine when Tb is visible, but access tells me when i hide the textbox that it can not set focus to hidden textbox Me.tbHidden.SetFocus tbHidden is the name of my Textbox, it works...

Hi there, how can i link an MDW file to a network stored database? I read that i need to enter some code but where and how? Please tell me thanks. MDW file and Database are both stored an a networkdirve thanks

Hi, i have a look up query and it works for all materials (approx. 2000) expect that description: Large aluminium profiles WITH ACCESSORIES Access even doesn`t find that one with the search funktion, anyone knows why? If i enter Large* it finds it in search funktion, but when i copy paste...

HI, i do have that query for the current stock. IT doubles the numbers for receipt and issue, so stock is not correct, and i do not why. Maybe someone has a clue? SELECT [Inventory Control].Lot, [Inventory Control].[Storeage Location], [Inventory Control].Description, Sum([Inventory...

Hi out there, well i have a strange problem, maybe someone of you could help me out. I have a multiuser database. There is a form in it for dates. Input mask is short date. When i do open the db on my pc, there is no problem. But on the other user PC, always when i do enter a date like...

Hi out there, i do have a problem and hope that some of you out there might help me. I am not good at coding VBA thats why i do not know how to solve. Problem: i do have a from for material issue. I want to check out if there is enough material in store to fit that issue. So i do have a tB to...

Hi, i have a database. this database is stored on a networkserver, and should open by default as shared. It works sometimes. But the problem is, that sometimes a error apears: "unregocnized databank format" with the networkpath of the DB. I can not save anzthing anymore. When i closed the DB and...

Hi out there, i do have a form with 2 textboxes, in this textboxes you can enter dates, a start date and a end date. I want access to look up only the records that are in between that dates, here is my SQL Statement: SELECT [Material Issue].[Quantity], [Inventory Control].[Description]...

Hi out there, i have a simple question. Is it possible to open a form in default with the settings for a new record? I want the from when it pops up to open empty, and after entering the first record, you should be able to browse throug the records. I am not familiar with codeing, tried to copy...

Hi, i have a very simple question. I do have a form, in that form i do have Textboxes for values. I need them because some incoming deliverys have another currency.I want the form to work that way: Case 1: no entry in first textbox (witch repesents Thai Baht), only entry in 2 Box (for Euro...

Hi, i have a form witch is based on a table. It has 7 fields. I want a combox to select records out of an other table, then when selected it should update 3 fields with the data that is connected to the selected record, and then enter in 3 boxes additional data and save it to the other table...

Hi, my proiblem is i want to have some sort off monitoring in my DB. I want to find out who changed what and when. Anyone an idea how to do that? I have no clue thanks

Hi, i am trying to design a form, where i have a combobox, and when i do select a value in that combobox, the infos belonging to that record will be added to the other textboxes, and i do enter additional information and then save it to a different table. Mz problem is that i am not able to do...